I've tried the function you gave, and it will put a name in the cell from the data tab, but I'm not sure what criteria it is using. It says that it is looking at A19, but the name it returns doesn't relate to that time.

for ex this is what I get:
0800-1005AMJohn1015-1220PMTim0120-0325PM
John doesn't have a 0800-10005AM class, not sure why it is returning his name. The time is what the formula says it is looking up.

I tried using this as my if true result, but I am just not having any luck getting getting any functions to look at my data for more than one criteria. I can have it return true If the room number in Data matches the room number specified on schedule, but I can't get it to return true if the room numbers match and the time matches. grrr!

It seemed like it should be such an easy thing to accomplish. I do it all the time by eyeball!

Thanks,


Erin

Hi Erin
Is it possible to past a copy of your spreadhseet here so we can try and help you.
OTPM

This is a more detailed sample of the spreadsheet that I am working from. The Data is on the Data tab and the schedule I want to create is on the Fall 2011 tab.

Attached Files

schedulesample.xlsx (20.4 KB, 15 views)

Hi Erin
I have had a play with your spreadsheet however I have been unable to find a solution. I am sure there is a formula that will do it and hopefully someone with more detailed skills than I will be able to help. I know you can do it with VBA but it will need a VBA expert to help.
Good luck.
Tony