About 1,940,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. IF + XLOOKUP Formula | Microsoft Community Hub

    May 21, 2022 · Hello, I am trying to put 2 formulas together. I have gotten the XLOOKUP formula to work perfectly, but not when I added the IF statement (only if the...

  5. Xlookup with nested IF | Microsoft Community Hub

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

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

  7. XLOOKUP wildcard matching issue | Microsoft Community Hub

    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?

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

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