The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.

Instead of using the HLOOKUP function in Excel to perform a horizontal lookup, simply use the XLOOKUP function. Note: the XLOOKUP function, entered into cell B2, fills multiple cells.

Jun 25, 2024 · XLOOKUP is a lookup function that searches a range or an array for a match and returns the corresponding item from a range or array in Excel.

Mar 20, 2026 · 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 …

Feb 6, 2020 · 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 function in Excel explained with practical examples. Look up values in any direction, return multiple columns, handle errors, and replace VLOOKUP cleanly.

Jan 15, 2026 · XLOOKUP will find the exact match of the product code in column A and return the price (from column C) in the same row. This is the basic functionality of any lookup function/formula.

Feb 2, 2024 · See how to use the XLOOKUP function for vertical and horizontal lookup in Excel. It can look in any direction, return last match, perform v-lookup or h-lookup with multiple criteria, two-way …

Aug 14, 2025 · How you use the XLOOKUP function changes when you have more than one criterion. Imagine you own a brand that sells six drinks in six different countries, and you have assigned a …

Aug 14, 2025 · The XLOOKUP function in Excel is a powerful and flexible tool designed to replace older lookup functions like VLOOKUP and HLOOKUP. Unlike these traditional functions, XLOOKUP can …