# VLOOKUP vs XLOOKUP in Excel

> Use XLOOKUP if everyone who opens the file has Excel 2021, 2024 or Microsoft 365.

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

Use XLOOKUP if everyone who opens the file has Excel 2021, 2024 or Microsoft 365. It defaults to an exact match, can return columns to the left of the search column, and handles missing values without a wrapper. Use VLOOKUP when the file has to work in Excel 2019 or earlier.

## The differences

|  | VLOOKUP | XLOOKUP |
|---|---|---|
| Available in | Every version | Excel 2021, 2024 and Microsoft 365 |
| Default match | Approximate, unless the 4th argument is FALSE | Exact |
| Which column comes back | A column number you count by hand | A range you point at |
| Inserting a column in the table | Can silently return the wrong column | Keeps working |
| Return a column to the left | Not possible | Yes |
| Value not found | #N/A, so you wrap it in IFERROR or IFNA | Built-in if_not_found argument |
| Search from the bottom up | No | Yes, with search_mode -1 |

## Same data, side by side

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| G2 | `=VLOOKUP(F2,A2:D6,3,FALSE)` | Sales | VLOOKUP: dept for the ID, counting 3 columns over |
| G3 | `=XLOOKUP(F2,A2:A6,C2:C6)` | Sales | XLOOKUP: same answer, pointing at the Dept column |
| G4 | `=XLOOKUP("Chen Wu",B2:B6,A2:A6)` | E-103 | XLOOKUP looks left: the ID for a name. VLOOKUP can't |
| G5 | `=XLOOKUP("E-999",A2:A6,C2:C6,"Not found")` | Not found | A missing ID returns a message instead of #N/A |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | ID | Name | Dept | Salary |  | ID to find | Result |
| 2 | E-101 | Ana Ruiz | Sales | $64,000 |  | E-104 | Sales |
| 3 | E-102 | Ben Cole | Finance | $71,000 |  |  | Sales |
| 4 | E-103 | Chen Wu | Ops | $58,000 |  |  | E-103 |
| 5 | E-104 | Dana Fox | Sales | $69,000 |  |  | Not found |
| 6 | E-105 | Eli Park | IT | $83,000 |  |  |  |

## When to use each

### Choose VLOOKUP when

Colleagues or clients open the file in Excel 2019 or earlier, or a template you must match already uses it. Always pass FALSE as the last argument.

### Choose XLOOKUP when

Everyone has a current version. It is shorter to write, harder to break, and reads like a sentence: find this, here, return that.

## The functions

- [VLOOKUP](https://spreadsheetpractice.com/functions/vlookup): VLOOKUP looks for a value in the first column of a table and returns a value from another column in the same row. Every current version.
- [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.

## Questions

### Will XLOOKUP replace VLOOKUP?

VLOOKUP still works and isn't going away, so existing files keep running. For new work in current versions, XLOOKUP is the better default.

### Is XLOOKUP slower than VLOOKUP?

Not in a way you'll notice in normal workbooks. Both are fast; XLOOKUP's binary search mode is faster still on very large sorted lists.

---

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