The XLOOKUP Syntax
Learn the lookup value, lookup array, and return array arguments.
Meet XLOOKUP
XLOOKUP is the modern replacement for VLOOKUP and HLOOKUP. It finds a value in one column (or row) and returns the matching value from another.
Its biggest win: you tell it where to search and what to return as two separate ranges. No counting columns, no worrying about which side your answer sits on.
XLOOKUP is available in Excel 365, Excel 2021, and Google Sheets.
The Three Core Arguments
The simplest XLOOKUP needs just three pieces of information:
- lookup_value - what you are searching for
- lookup_array - the range to search in
- return_array - the range to pull the answer from
Read the formula as: find this value, in this column, and give me the matching item from that column.
=XLOOKUP(lookup_value, lookup_array, return_array)