Multi-Variable Lookup help
I am working on a room scheduling spreadsheet.
on one tab I have a list of rooms and the times and days they are in use and who is using them. On the second tab is a more visual display of the information so you can see a rooms use at a glance. I've attached a sample.
I want it to look at the data sheet, and if the room is in use at a specific date and time I would like it to put the name of the person on the schedule.
IF Data! A:A=any of the variables in schedule! I:I AND Data! B:B=schedule! A2 AND Data! C:C= schedule! B1
THEN return Data! column D in cell schedule!B2
Would be nice but not essential to have it return "CONFLICT" if more than one match was found.
I show a sample of what I want to look like on the schedule tab.
I have tried a variety of IF(AND()) and VLOOKUP functions, but I am just not familiar enough with them to make them work, if they can.
The data is pulled from a class scheduling program and I would love to be able to automate this!
|