About 1,930,000 results
Open links in new tab
  1. Annoucing XLOOKUP, successor to the iconic VLOOKUP

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

  2. How to optimize a large XLOOKUP table with volatile data sources?

    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 …

  3. Excel XLOOKUP and XMATCH - techcommunity.microsoft.com

    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.

  4. Formula Help - XLookup + average | Microsoft Community Hub

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

  5. Excel 2024: Twelve Benefits of XLOOKUP

    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 …

  6. XLOOKUP IN LIST OPTION OF DATA VALIDATION | Microsoft …

    Sep 23, 2021 · XLOOKUP IN LIST OPTION OF DATA VALIDATION PC/Windows 10/Excel 365 This appears to be a simple issue with a simple solution - then again, there may be no …

  7. Xlookup with nested IF | Microsoft Community Hub

    Dec 12, 2024 · For real life application, I would be replacing "Smith" with a cell reference and "yes" with another cell reference. But for the example, if A=yes, then return D if Col C=Smith. I …

  8. Xlookup to return cell text + hyperlink | MrExcel Message Board

    Oct 17, 2023 · Hey, im looking for a formula that returns the hyperlink from the result of the xlookup from another sheet. i got a "sheet1" and "sheet2": In the "sheet1" im using xlookup to …

  9. Xlookup - not found on the desktop version | Microsoft …

    Jan 29, 2024 · If the XLOOKUP function is not available because it is restricted to Microsoft 365 users and you need a non-VBA alternative that works on Excel versions prior to Microsoft 365, …

  10. XLOOKUP returning #N/A for some values when the values are there

    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 …