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.

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 each element until …

Jul 8, 2024 · The new XLOOKUP function has been rolled out to Office 365 in November 2019. Joe McDaid of the Excel team designed XLOOKUP to unify the people who use VLOOKUP and the …

Jun 29, 2024 · XLOOKUP wildcard matching issue Hello, I can't figure out why the XLOOKUP formula in the attached file is returning only 1 match when there should be 3. Any ideas?

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 different …

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...

Apr 24, 2025 · Yes. Actually XLOOKUP was a welcome addition to replace the traditional INDEX ( MATCH () ) combination that was previously required in certain cases.

Oct 3, 2022 · Xlookup not returning value for all cells that match criteria I am handling data on a month to month basis of around 800-1300 tickets so I needed an easy way to edit prices that change on a …

Feb 19, 2022 · How to use XLOOKUP in scenario where I want the latest date with AVAILABLE data? Hello, May I ask, if you could open the attached excel, currently I am trying to use XLOOKUP formula …