Forum Discussion
Solved
Index and Match command is return results from the wrong column
Within Excel I'm using the Index and Match command to search an array. I've provided copy of the workbook. Here is the command =IFERROR(INDEX(D7:H11,MATCH($D$13,L7:L11,0),MATCH($E$13,M7:M11,0)),"") ...
Hi,
Try this formula in cell G13:
=XLOOKUP(TRUE, C7:C11 = D13, D7:H11) XLOOKUP(TRUE, D6:H6 = E13, D7:H11)or this formula:
=INDEX(D7:H11, MATCH(D13, C7:C11, 0), MATCH(E13, D6:H6, 0))Hope this helps.
Regards,
IlirU
Hi,
Try this formula in cell G13:
=XLOOKUP(TRUE, C7:C11 = D13, D7:H11) XLOOKUP(TRUE, D6:H6 = E13, D7:H11)
or this formula:
=INDEX(D7:H11, MATCH(D13, C7:C11, 0), MATCH(E13, D6:H6, 0))
Hope this helps.
Regards,
IlirU
