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