I have a spreadsheet with
A - Day of week
B - Time of Day
C - etc - Employee names
Day Time Amy P Angel M Chad S Deborah J
Monday 6:00 AM AUX
Monday 6:15 AM AUX
Monday 6:30 AM AUX
Monday 6:45 AM AUX
Monday 7:00 AM AUX
Monday 7:15 AM AUX
Monday 7:30 AM Phone AUX
Monday 7:45 AM Phone AUX
Monday 8:00 AM Phone Break
Monday 8:15 AM Phone AUX
Monday 8:30 AM Aux Phone AUX
Monday 8:45 AM AUX Phone AUX
Monday 9:00 AM AUX Phone AUX
Monday 9:15 AM AUX Phone Phone
Monday 9:30 AM AUX Break Phone
Monday 9:45 AM AUX Phone Phone


Rows indicate what job function they are doing each 15 minutes throughout
the day.

I need to create a formula that will tell me which employees are doing a
particular job function (break, lunch, etc), on a specific day (Tues) for
a certain time (9:15 am)
I have a separate worksheet started with
Day of week, job function and time and list each employee under it,
Monday
Phones
10:00 AM

Amy P ?????
Angel M ?????
Chad S ?????
Deborah J ???
Can anyone help me?