Formula Help using multiple criteria

[Kamille824]

Need help creating a multi criteria formula using the following of what my data is.
Column A - Day of Week
Column B - Time of day (15 min increments)
Column Employee Names in Row 1 and job function description (AUX, Open, Break, Lunch)

On a separate worksheet I am looking at creating a formula by changing the day of the week, time and job function (Aux, Open, Break etc) and having it display which employees are doing that particular function at the given time listed.

Monday AUX
8:30AM to 9:00AM


Amy P Yes
Angel M NO
Chad S NO
Deborah J Yes

Can this be done? Hope this makes sense..... I can email the data sheet if needed. Appreciate any feedback.
Thanks
Kamille