I'm trying to find a way to find to use 3 references to return a value using INDEX and MATCH, but whenever I'm using a third reference, Excel gives me the #REF! error, i.e., I want do a formula that finds the start time of an employee. First I'm matching name and day like this:
(this is using one horizontal and one vertical match, and until this point, everything works fine)
The problem is when I want to add a third MATCH where: MATCH(Shift Start, Sheet!$B$3:$BU$3,0)
Taking in consideration the raw data displayed is like this:
and I want the range to be dynamic depending if what we want to get is the Shift Start or the Break 2 End on a Monday, but using the same formula. Any thoughts?