formula for roster (Indexmatch, and IF)

[denistrevisan]

Hello, I am trying to make a small table that returns the name of the staff that works in today date based on a specific branch and shift.
The range will be in the roster data.
The result that I want is only the name of the specific staff that is working in that location and specific shift.

If you can guide me to the right formula. thank you very much