Google Sheets reference
XLOOKUP in Google Sheets
Not available in Sheets1 worked example
Not available in Google Sheets
XLOOKUP does not exist in Google Sheets
XLOOKUP is not available in Google Sheets. Use VLOOKUP with an exact match, or the MATCH + INDEX combination instead.
Use the generator to get a Google Sheets alternative:
Find a Google Sheets alternativeAlso in Excel
See the full XLOOKUP reference for Excel — including all worked examples, common errors, and FAQ.
XLOOKUP Excel reference →