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
- XLOOKUPThe modern lookup: find a value in one range and return the matching entry from another, in any direction. It replaces most VLOOKUP and INDEX/MATCH uses.
- VLOOKUPThe classic lookup: find an item in the first column and fetch something from the same row. Common in interviews, though XLOOKUP is the modern choice.