Forum Discussion
Solved
Return Values from Other Tabs
I'm trying to return what the values from tab 1 for duty & tab 2 for location in tab 3 log Tab 1 duty rota Date John Zack 01/02 SDP NCQ Tab 2 l...
=INDEX($B$8:$F$9,MATCH(D13,$A$8:$A$9,0),MATCH(B13,$B$7:$F$7,0))
An alternative could be INDEX and MATCH. In cell E7 i've replaced "Thu" by "Thur" to return an exact match.
=INDEX($B$8:$F$9,MATCH(D13,$A$8:$A$9,0),MATCH(B13,$B$7:$F$7,0))
An alternative could be INDEX and MATCH. In cell E7 i've replaced "Thu" by "Thur" to return an exact match.
Edited response. Troubleshooting formula later tonight