Formula Library

INDEX/MATCH

lookup

A powerful combination that returns a value from a table by matching both row and column. More flexible than VLOOKUP.

Syntax

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Example

Excel
=INDEX(B:B, MATCH(E2, A:A, 0))

Finds the row where E2 matches in column A, then returns the value from that same row in column B.

Tips & Notes

  • →Use 0 in MATCH for exact match
  • →Can look up to the left (unlike VLOOKUP)
  • →Works with dynamic arrays in modern Excel

See Also

VLOOKUPXLOOKUP

Need a custom INDEX/MATCH formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.