Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Instead of using INDEX and MATCH in Excel to perform a left lookup, simply use the XLOOKUP function. For example, take a look at the XLOOKUP function below. Explanation: the XLOOKUP function looks up the last name and returns the ID. The XLOOKUP function in Excel 365/2021 can return multiple values. 1.
XLOOKUP is a function that allows you to quickly look for a value in a dataset (vertical or horizontal) and return the corresponding value in some other row/column.
XLOOKUP is Excel's modern all‑in‑one lookup function. It lets you search a row or column for a value and retrieve the corresponding value from another range, without the frustrating limitations that plagued older functions like VLOOKUP, HLOOKUP, and LOOKUP.
Sounds easy, right? 😎 We will start the XLOOKUP function with a simple example. Let’s use the XLOOKUP function and find the price for the given product code in cell F1.