Can IF(INDEX(MATCH())) return true for multiple rows?
I'm trying to develop a formula for the Booked column that will return true if the value in Date/Time is found in another sheet. That much I can do, but my problem is that the timeslots are 4 hours long so I need it to return true for the three following rows as well.
For example, if the first timeslot (9:00-1:00) in the screenshot is booked, I need the 10:00-2:00, 11:00-3:00, and 12:00-4:00 slots to show as booked too. But if the 1:00-5:00 slot is booked, it should not return true for the three slots below as they are on the following day.
Hopefully my requirements are clear. Any answers/links to similar questions would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!