Compare two columns from a table and get value from third column

[Megaboost]

I have a table of data with employee schedules for different events.




I am trying to represent the data in a weekly view separately to show for each day of the week which employees are scheduled for different events.


In the attached spreadsheet, in cell H6, I want to query [Shedule] table for events on the July 29 (H4) for employee Ron (F6).