Can XLOOKUP fully replace VLOOKUP?

In almost every case: it searches in both directions, handles "not found" natively without the #N/A trap, and doesn't require the key column to be on the left.

Why use IFERROR instead of IF(ISERROR(...))?

IFERROR evaluates the formula once instead of twice, which is more readable and faster on large sheets.

Office

Advanced Excel functions

XLOOKUP vs INDEX/MATCH, IFERROR, FILTER and SORT: the functions that turn a patched-together spreadsheet into a robust one.

Premium Updated on September 11, 2026

VLOOKUP, XLOOKUP and INDEX/MATCH

This sheet is for members

Create a free account and read up to 3 premium sheets a month. Or go Premium for unlimited access.

Create a free account See Premium

Already have an account? Log in

#Excel

VLOOKUP, XLOOKUP and INDEX/MATCH

This sheet is for members

Related sheets