About 1,980,000 results
Open links in new tab
  1. 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.

  2. XLOOKUP returning #N/A for some values when the values are …

    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 …

  3. XLOOKUP when lookup value may be text string or number …

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

  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. XLOOKUP and Dynamic Ranges | Microsoft Community Hub

    XLOOKUP and Dynamic Ranges XLookup is a great addition to Excel. Looks particularly promising when combined with Dynamic Arrays. There is one scenario I'm not sure has been …

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

  8. Xlookup with nested IF | Microsoft Community Hub

    Dec 12, 2024 · XLOOKUP( TRUE, BYROW(lookup_array = lookup_values, AND), return_array ) ); will allow you to lookup a row of values in the corresponding range of the data array using a …

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

  10. xlookup not finding number/letter mix | Microsoft Community Hub

    Feb 7, 2020 · Diamond Contributor to Kslaz May 22, 2023 Kslaz XLOOKUP itself is not dramatically slower than INDEX/MATCH or VLOOKUP in same scenarios. Depends on how …