Compare two columns from a table and get value from third column
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).
|