# INDEX MATCH vs VLOOKUP: Which Lookup Should You Use?
> INDEX MATCH vs VLOOKUP compared: looking left, inserting columns, two-way lookups and how much each formula asks you to type. One worked example, one verdict.

- Web page: https://logicexcel.com/functions/index-match-vs-vlookup
- Language: en
- Updated: 2026-11-19
- Practice this in the browser: https://logicexcel.com/practice/23

**Verdict:** use VLOOKUP for a quick lookup when the value you search for is in the first column of the table. Use INDEX and MATCH when it is not, when columns may be inserted later, or when you need a two-way lookup. INDEX and MATCH are more flexible and work in every version of Excel; VLOOKUP is shorter to write.

Both approaches find a value in one column and return something from the same row. VLOOKUP does it in one function. INDEX and MATCH split the job in two: MATCH finds the row, and INDEX returns the value from that row. That split is why INDEX and MATCH can do things VLOOKUP cannot.

## The short answer

- **VLOOKUP** is one function, so it is faster to type and easier to read, but it searches only the first column of its table.
- **INDEX and MATCH** are two functions, so the formula is longer, but the search column and the return column are separate. That lets you look left and survive inserted columns.
- Neither is wrong. Pick by the shape of the sheet.

## Side by side

| | VLOOKUP | INDEX and MATCH |
| --- | --- | --- |
| Formula | `=VLOOKUP(lookup, table, col_number, FALSE)` | `=INDEX(return_range, MATCH(lookup, lookup_range, 0))` |
| Looks left of the lookup column | No | Yes |
| If you insert a column in the table | The column number does not follow, so the result can change | The ranges adjust, so the result stays right |
| Exact match | Type `FALSE` (or 0) as the last argument | Type `0` as the last argument of MATCH |
| Two-way lookup (row and column) | Needs a second function | Two MATCH functions inside one INDEX |
| Excel versions | All | All |

## The same lookup, both ways

The same price list, with the SKU to find, A103, typed in E2.

| | A | B | C |
| --- | --- | --- | --- |
| 1 | **SKU** | **Product** | **Price** |
| 2 | A101 | Notebook | 4.50 |
| 3 | A102 | Pen | 1.20 |
| 4 | A103 | Stapler | 8.90 |
| 5 | A104 | Folder | 2.10 |
| 6 | A105 | Scissors | 6.40 |

To return the price for the SKU in E2:

```
=VLOOKUP(E2,A2:C6,3,FALSE)
=INDEX(C2:C6,MATCH(E2,A2:A6,0))
```

Both return 8.90. In the INDEX and MATCH version, `MATCH(E2,A2:A6,0)` returns 3, the position of A103 in the SKU column, and `INDEX(C2:C6,3)` returns the third price.

To look left, find the SKU for the product name typed in F2:

```
=INDEX(A2:A6,MATCH(F2,B2:B6,0))
```

VLOOKUP cannot return a column to the left of the one it searches.

For a two-way lookup, find the price in a table with products down the side and months across the top:

```
=INDEX(B2:D6,MATCH(G1,A2:A6,0),MATCH(G2,B1:D1,0))
```

The first MATCH picks the row, the second picks the column, and INDEX returns the cell where they meet.

## Which one should you use?

**Choose VLOOKUP** for a short, one-off lookup where the key is the first column and the table will not change shape.

**Choose INDEX and MATCH** when the key is not the first column, when you expect to insert or move columns, when you need a two-way lookup, or when you are building a model other people will edit.

**Consider XLOOKUP** if everyone who opens the file has Excel 2021 or later or Microsoft 365: it does the same job as INDEX and MATCH in one function. See [XLOOKUP vs VLOOKUP](https://logicexcel.com/functions/xlookup-vs-vlookup).

## Practice the difference

Type both formulas yourself. The [INDEX MATCH lookup lesson](https://logicexcel.com/practice/23) is marked as you go, and the [VLOOKUP lesson](https://logicexcel.com/practice/11) covers the older function. If you want a path rather than one function, the [Excel courses](https://logicexcel.com/learn/excel-courses) start free, and each one ends in a marked exam. More on each function: [INDEX and MATCH](https://logicexcel.com/functions/index-match) and [VLOOKUP](https://logicexcel.com/functions/vlookup).

## FAQ

### Is INDEX MATCH better than VLOOKUP?

It is more flexible, not always better. INDEX and MATCH can look left, keep working when you insert a column and handle two-way lookups. VLOOKUP is shorter and easier to read, so it is a fine choice when the key is the first column and the table is stable.

### What does the 0 in MATCH mean?

The 0 is the match type and means exact match. MATCH(E2,A2:A6,0) looks for the value in E2 and returns its position, or an error if it is not there. Leave it out and MATCH assumes a sorted list and can return a nearby position.

### Does INDEX MATCH work in every version of Excel?

Yes. INDEX and MATCH are in every current version of Excel, including the ones that do not have XLOOKUP, so a file that uses them opens correctly in older versions.

### Should I learn XLOOKUP instead of INDEX MATCH?

Learn XLOOKUP if your Excel has it, because it does the same job in one function. Learn INDEX and MATCH too if you share files with people on older versions or use sheets that already contain them.
