Hi,
I have a sample excel sheet attached, basically I have 3 criteria and want to return the cost from the data table I have tried to use the formula below, works fine when I'm search just 1 cell i.e. B2=A3 but when searching a range B2:G2=A3 it comes back with N/A:
=INDEX(Sheet1!B4:G6,MATCH(1,IF(Sheet1!B2:G2=A3,IF(Sheet1!B3:G3=A4,IF(Sheet1!A4:A6=A6,1))),0))
A3 - Location
A4 - Total Cost
A6 - Manager
I am trying to return the Manager cost from a data table on Sheet 1 B4:G6. If you could help I would be grateful.
Bookmarks