FormulaRescue

Fix INDEX MATCH formula errors

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.

Formula repair
Excel errors
No workbook upload

Common examples

=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.

FAQ

Why does INDEX MATCH return the wrong row?

The lookup range and return range may not line up.

Can FormulaRescue fix nested formulas?

It can help with many nested formulas, especially if you include the error message.

Should I use XLOOKUP instead?

XLOOKUP can be simpler, but INDEX MATCH is still useful in many workbooks.

Try FormulaRescue

Paste your broken Excel formula into the main FormulaRescue tool and get a corrected version back.

Rescue a formula

Related Excel formula pages