Hi all,
Getting used to using INDEX and MATCH as a multiple criteria VLOOKUP, but have come to a dead end on this one approach.
We have a meeting room at work where people need to write in a book to "claim" the room for that time, but no one uses the book. So I came up with an idea for a spreadsheet that they can just check whenever they want to see if the room is booked.
On the left in column A, I have times from 09:00 to 17:30, showing every half hour between those times. There's also a date at the top of column A. Column B results will change depending on the date - this data comes from the table on the right (G2:J7). Adam has booked a meeting from 09:00 to 09:59, and in column A at 09:00, it shows his name, but not at 09:30. I'm really not sure on how to display his name in that gap where an error shows at 09:30.
Does anyone have an idea on how to do that? All help appreciated.
Getting used to using INDEX and MATCH as a multiple criteria VLOOKUP, but have come to a dead end on this one approach.
We have a meeting room at work where people need to write in a book to "claim" the room for that time, but no one uses the book. So I came up with an idea for a spreadsheet that they can just check whenever they want to see if the room is booked.
On the left in column A, I have times from 09:00 to 17:30, showing every half hour between those times. There's also a date at the top of column A. Column B results will change depending on the date - this data comes from the table on the right (G2:J7). Adam has booked a meeting from 09:00 to 09:59, and in column A at 09:00, it shows his name, but not at 09:30. I'm really not sure on how to display his name in that gap where an error shows at 09:30.
Does anyone have an idea on how to do that? All help appreciated.