Excel XLOOKUP Formula
Learn how to use XLOOKUP formula in Excel.
Syntax
Copy formula manually
=XLOOKUP(lookup_value, lookup_array, return_array)
Example
=XLOOKUP(A2,D2:D20,E2:E20)
Try XLOOKUP with Two Files
Upload two CSV or Excel files. Select matching columns from both files, choose the value you want to return from File B, and generate a lookup result like Excel XLOOKUP.
File A — Main Data
File B — Lookup Data
XLOOKUP is the modern replacement for VLOOKUP.
Formula Examples
| Input | Formula | Output |
|---|---|---|
| 101 | =XLOOKUP(A2,D:D,E:E) | John |