INDEX MATCH formulas are flexible, but small range mistakes can cause incorrect results or errors.
FormulaRescue can help repair the structure and make the formula valid again.
=INDEX(C:C,MATCH(A2,B:B,0))Looks up A2 in B:B and returns the matching value from C:C.
=INDEX(C2:C10,MATCH(A2,B2:B20,0))Ranges should generally align in length.
=INDEX(A:D,MATCH(A2,A:A,0),4)Returns from the fourth column of A:D.
The lookup range and return range may not line up.
It can help with many nested formulas, especially if you include the error message.
XLOOKUP can be simpler, but INDEX MATCH is still useful in many workbooks.
Paste your broken Excel formula into the main FormulaRescue tool and get a corrected version back.
Rescue a formula