How to use XLOOKUP in Google Sheets
In Google Sheets, XLOOKUP is a modern and flexible alternative for VLOOKUP, to find a value from a table or a list and then return a related result.
In this example, we'll retrieve an employee's email based on their ID:
Formula in G4
👇 Try changing this value
- Enter =XLOOKUP in cell G4, where you want the Email address to appear.
- Enter the Lookup value G3, containing the ID (103) you want to look for.
- Enter the Search range B3:B6, the range of data that contains all the ID values.
- Enter the Result range D3:D6, containing the Email values your want to return.
The final formula is:
=XLOOKUP(G3, B3:B6, D3:D6)
XLOOKUP returns the value in D5, which is firstname.lastname@example.org.