fx =INDEX(C1:C100,MATCH(E1,A1:A100,0))ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

INDEX/MATCH Formula for Lookup

Flexible lookup - more powerful than VLOOKUP. Copy-paste ready for Excel, Google Sheets, and Airtable.

=INDEX(C1:C100,MATCH(E1,A1:A100,0))
When you need this: When you need to look up a salary (column C) for an employee name in E1 from a list in column A.

How it works

  1. 1The MATCH function finds the position of E1 (employee name) in A1:A100 and returns the row number.
  2. 2The INDEX function returns the value at that row position from C1:C100 (salary column).
  3. 3Together: search flexibly, then return the right column (unlike VLOOKUP which only searches left to right).

Variations

INDEX/MATCH with error handling
=IFERROR(INDEX(C1:C100,MATCH(E1,A1:A100,0)),"Not Found")
Two-way lookup (row & column)
=INDEX(B2:E100,MATCH(A1,A2:A100,0),MATCH(B1,B1:E1,0))

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)LookupSORT — Sort a range dynamicallyLookup

Need a formula that's not here?

Generate custom formula →