VLOOKUP vs INDEX/MATCH in Excel: When to Use Each
2026-03-18
Basic VLOOKUP
VLOOKUP searches the first column of a range and returns a value from a specified column. Simple and readable:
=VLOOKUP(E1, A1:D100, 3, FALSE)Equivalent INDEX/MATCH
INDEX/MATCH does the same thing but can look left, which VLOOKUP cannot:
=INDEX(C1:C100, MATCH(E1, A1:A100, 0))Left Lookup (INDEX/MATCH Only)
Need to look up a value to the left of the search column? Only INDEX/MATCH can do this:
=INDEX(A1:A100, MATCH(E1, C1:C100, 0))When to Use VLOOKUP
Use VLOOKUP when your lookup column is on the left, the table is simple, and you want readable code. Use INDEX/MATCH when you need left lookups, performance matters on large datasets, or you want to avoid column number counting.
Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free