Resources > Formula Help
How Do I Use INDEX MATCH in Excel?
Last Updated: June 2026
Quick Answer
INDEX MATCH combines two functions to perform lookups more flexibly than VLOOKUP.
=INDEX(B:B,MATCH(E2,A:A,0))
MATCH finds the row number. INDEX returns the value from that row.
Why Use INDEX MATCH?
- Can look left or right
- More resilient than VLOOKUP
- Works well in large models
Modern Alternative
For newer versions of Excel, XLOOKUP is often easier:
=XLOOKUP(E2,A:A,B:B)
