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!

Attached Files

schedulesample.xlsx (10.7 KB, 21 views)