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.

May 8, 2025 · Looking for Xlookup with IF function Hi! I'm trying to find a formula that allows me to search for a sku in column E but I need the return to be based on whether or not the cell in column F …

Mar 18, 2026 · Hi all, I'm preparing a score sheet to record shooting scores for school sport. I would like the overview tab to pull the students score from where it is recorded under the training (Tues or Wed) …

Aug 8, 2025 · How to optimize a large XLOOKUP table with volatile data sources? I'm working with a fairly large Excel workbook (around 100,000 rows) that relies heavily on XLOOKUP functions to fetch …

Mar 23, 2026 · XLOOKUP (MAX (scores), scores, players) ) This filters the data to the selected board game and scenario, finds the highest score in that subset, and returns the player for that score. If …

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

Jul 9, 2023 · XLOOKUP is a powerful function in Excel that can help you look up values in a table or range by row or column. It can also be used to look up values based on multiple criteria.