# XLOOKUP vs INDEX and MATCH in Excel

> They do the same job. XLOOKUP is one function with readable arguments; INDEX and MATCH is a two-function pattern that works in every version of Excel.

Source: https://spreadsheetpractice.com/functions/compare/xlookup-vs-index-match · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

They do the same job. XLOOKUP is one function with readable arguments; INDEX and MATCH is a two-function pattern that works in every version of Excel. Learn both: XLOOKUP for your own work, INDEX/MATCH for files that travel.

## The differences

|  | XLOOKUP | INDEX and MATCH |
|---|---|---|
| Available in | Excel 2021, 2024 and Microsoft 365 | Every version |
| Formula | One function, three arguments | Two functions nested together |
| Default match | Exact | MATCH defaults to approximate, so you add 0 |
| Value not found | Built-in if_not_found | #N/A, so you wrap it in IFERROR |
| Two-way lookup (row and column) | One XLOOKUP inside another | INDEX with two MATCH functions |
| Return a column to the left | Yes | Yes |

## Same data, side by side

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| H2 | `=XLOOKUP(F2,A2:A5,C2:C5)` | 95 | XLOOKUP: Q2 units for the product in F2 |
| H3 | `=INDEX(C2:C5,MATCH(F2,A2:A5,0))` | 95 | INDEX/MATCH: the same answer, in any version |
| H4 | `=INDEX(B2:D5,MATCH(F2,A2:A5,0),MATCH(G2,B1:D1,0))` | 95 | Two-way: product row and quarter column, both from cells |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Q1 | Q2 | Q3 |  | Product | Quarter | Result |
| 2 | Lamp | 120 | 135 | 150 |  | Desk | Q2 | 95 |
| 3 | Desk | 80 | 95 | 88 |  |  |  | 95 |
| 4 | Chair | 210 | 190 | 240 |  |  |  | 95 |
| 5 | Shelf | 45 | 60 | 52 |  |  |  |  |

## When to use each

### Choose XLOOKUP when

You and your readers have a current version and you want formulas that are quick to read and audit.

### Choose INDEX and MATCH when

The file must open in Excel 2019 or earlier, or you're reusing one MATCH result in several INDEX formulas.

## The functions

- [XLOOKUP](https://spreadsheetpractice.com/functions/xlookup): XLOOKUP searches one column or row for a value and returns the matching item from another. Excel 2021, 2024 and Microsoft 365.
- [INDEX](https://spreadsheetpractice.com/functions/index): INDEX returns the value at a given row and column of a range: INDEX(A2:C10,4,2) is the fourth row, second column. Every current version.
- [MATCH](https://spreadsheetpractice.com/functions/match): MATCH returns the position of a value in a row or column: 3 means the third cell. Every current version.

## Questions

### Is INDEX MATCH faster than XLOOKUP?

Speed is close enough not to matter in typical workbooks. Choose based on which versions need to open the file.

### Why does my INDEX MATCH return the wrong row?

MATCH is probably doing an approximate match. Add 0 as its third argument: MATCH(value, range, 0).

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
