INDEX MATCH vs VLOOKUP in Google Sheets
Short answer: INDEX/MATCH is the more robust pair — it looks in any direction, doesn't break when columns move, and only reads the two columns it needs. VLOOKUP is shorter and easier to remember for simple right-of-key lookups.
Copy the one most people want (INDEX/MATCH)
=INDEX(Sheet2!C:C, MATCH(A2, Sheet2!A:A, 0))
MATCH finds the row where A2 lives in column A; INDEX returns that row's value from column C. Change layout freely — nothing is hard-coded to a column number.
INDEX/MATCH vs VLOOKUP — the differences that matter
| Aspect | INDEX/MATCH | VLOOKUP |
|---|---|---|
| Lookup direction | Any direction — result column can be left of the key. | Result must be right of the key column. |
| Column inserts | Safe — you point at real ranges, not a number. | Breaks — the index number no longer matches after an insert. |
| Length / learning curve | Two functions nested; a little more to type. | One function; easiest to teach. |
| Performance on wide tables | Reads only the key and result columns. | Scans the whole table width from the key rightward. |
Which one should you use?
Use INDEX/MATCH when…
The value you want is to the left of the key, columns will be inserted or reordered, the table is very wide, or you want a lookup that won't silently break.
Use VLOOKUP when…
A quick, simple lookup where the result is a few columns to the right and the layout is stable — and you value the shorter, more familiar syntax.
Same task, both formulas
Return the price (column C) for the product code in A2, where codes are in column A.
=INDEX(Sheet2!C:C, MATCH(A2, Sheet2!A:A, 0))
=VLOOKUP(A2, Sheet2!A:C, 3, FALSE)
Both return the price. Insert a column before C and VLOOKUP's "3" now points at the wrong data, while INDEX/MATCH keeps working.
FAQ
Is INDEX MATCH faster than VLOOKUP?
On very wide tables, yes — it only reads two columns. On small sheets the difference is invisible.
Why do people prefer INDEX MATCH?
It looks left, survives column inserts, and doesn't rely on a hard-coded column number — so it breaks far less often.
Is XLOOKUP a replacement for both?
Largely, yes. XLOOKUP gives INDEX/MATCH-style flexibility with VLOOKUP-style simplicity, if your sheet supports it.
→ Google Sheets formulas cheat sheet — 34 copy-paste formulas