About 2,000,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. 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.

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

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

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

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

  8. Help - Find the 2nd match using Xlookup | Microsoft Community …

    Feb 12, 2021 · Help - Find the 2nd match using Xlookup Is there a way using XLookup to return the 2nd (or 3rd, or 4th, or whatever) match in the lookup value? I'm also trying to use as few …

  9. USING XLOOKUP WITH YES AND NO - MrExcel

    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?

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