Excel / 6 min read

INDEX MATCH Formula Examples for Flexible Lookups

Use INDEX MATCH when you need flexible lookups, better compatibility, or more control than VLOOKUP provides.

INDEX MATCH is a flexible lookup pattern that works when the return column is left of the key, when compatibility matters, or when you want clearer control over the lookup logic.

Check this first

Make sure the MATCH range and lookup value refer to the same type of key.
Use 0 in MATCH for exact lookups unless approximate mode is intentional.
Keep the INDEX return range aligned with the MATCH range.
Test MATCH alone first if the combined formula fails.

Working examples

Exact-match INDEX MATCH

=INDEX(G2:G20, MATCH(A2, F2:F20, 0))

Why INDEX MATCH is still worth learning

INDEX MATCH is older than XLOOKUP but still valuable. It gives you compatibility with many Excel environments while remaining more flexible than VLOOKUP.

It also teaches the logic of lookups more clearly because the position search and returned value are separated.

A good debugging habit

Run MATCH by itself first. If MATCH returns the wrong position, the problem is in the key or source column. If MATCH is correct but INDEX returns the wrong value, the return range is misaligned.

Test MATCH alone.
Check exact-match mode first.
Align ranges carefully before nesting.

Where it fits today

If you control the Excel version, XLOOKUP is often nicer. If you need broad compatibility or want a durable lookup pattern for older workbooks, INDEX MATCH is still a smart choice.