Is XLOOKUP available in Google Sheets?

Yes, it is a native function there. The lookup, return, not-found, match-mode and search-mode arguments follow the same order as in Excel.

Google Sheets function

XLOOKUP in Google Sheets

XLOOKUP is built into Google Sheets, with the same argument order as the Excel version shown here.

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

When the result range has several columns, the formula returns the whole matching row and spreads it across the neighbouring cells.

For a fuller explanation of the arguments and common errors, see the XLOOKUP Excel guide.

Formula: F2: =XLOOKUP(E2,A2:A4,C2:C4)

Result: 18.5

Searches A2:A4 and returns the item in the same position of C2:C4. Exact match is the default.

Formula: E2: =XLOOKUP(D2,A2:A3,B2:B3,"Not in catalog")

Result: Not in catalog

The fourth argument replaces #N/A with your own text.

Formula: D2: =XLOOKUP(1043,B2:B4,A2:A4)

The return range (names) sits left of the search range (IDs). VLOOKUP cannot do this.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in F2: =XLOOKUP(103,A2:A6,B2:B6,"none")

Result in F2: Lamp

Is XLOOKUP available in Google Sheets?: Yes, it is a native function there. The lookup, return, not-found, match-mode and search-mode arguments follow the same order as in Excel.

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.