Array-enter (=commit the formula to the sheet with
Ctrl+Shift+Enter, not just
Enter) this formula in cell
G5, then copy down and across:
Code:
=IFERROR(INDEX(Schedule[Event],MATCH(G$4&"|"&$F5,Schedule[Date]&"|"&Schedule[Employee],0)),"")
The above is in the attached.
Another way, not needing array-entering, is to enter the following in cell G5:
Code:
=IFERROR(INDEX(Schedule[Event],INDEX(MATCH(G$4&"|"&$F5,Schedule[Date]&"|"&Schedule[Employee],0),,)),"")
but then you can't copy across and down as before, but instead, select the whole range G5:M8 starting with G5 then press
F2 on the keyboard (or just click in the formula) and then holding just the
Ctrl key, press
Enter.
(Yes, you can do this in one step by selecting G5:M8, put the formula in the formula bar, hold
Ctrl and press
Enter.)