Aug 28, 2019 · We are excited to announce XLOOKUP, Excel's most powerful lookup function and the successor to the iconic VLOOKUP.

Jan 31, 2025 · Allow XLOOKUP and XMATCH to match against parts of text in a cell, or by any other pattern of text that can be described with regex.

Mar 13, 2023 · I have a data set that has lookup value which may be text string or number formatted as text, with the lookup range formatted General.  How can I format...

Jul 14, 2020 · Hello,  I am trying to work out a formula where, XLOOKUP finds the data in 3 different worksheets, and gives me the average, however, whenever it...

Sep 23, 2021 · Basically, when I use XLOOKUP formula (in List option of Data Validation) on an array it displays the "named range" INSTEAD of the data list associated with the "named …

Dec 12, 2024 · = XLOOKUP("Smith", IF(answer="Yes", name), value, "Name not found") This formula replaces names in the search array by FALSE if the other condition/s are not satisfied. …

Aug 8, 2025 · A fully optimized XLOOKUP works with sorted data and is arranged to spill. XLOOKUP performs a linear search by default which means it starts from the top and checks …

May 16, 2003 · I am having trouble finding syntax for XLOOKUP where as if a value is found in my lookup, xlookup returns YES, and if not found, xlookup returns NO. Can someone assist?

Nov 16, 2023 · XLOOKUP returning #N/A for some values when the values are there I am trying to use XLOOKUP to find an identifying number from a separate spreadsheet, referenced by a …

Mar 29, 2017 · I couldn't use an XLOOKUP with the "-1" search-mode switch, because open orders not yet received were returning blank cells from AZ (no receipt date). To circumvent the …