Practice free

VLOOKUP vs XLOOKUP

Draft. The steps on this page have not been checked in desktop Excel yet.

Both find an item and return a matching value. XLOOKUP is the newer of the two and is not in older versions of Excel.

The short version

Use XLOOKUP when everyone who opens the workbook has a version of Excel that includes it. Use VLOOKUP when the workbook has to open in older versions.

Functions used