What Excel Version Has XLOOKUP? A Practical Guide
Discover which Excel versions support XLOOKUP and how to verify compatibility. This XLS Library guide covers minimum requirements, upgrade paths, and practical tips for using XLOOKUP in Excel for Microsoft 365 and Excel 2019+.
XLOOKUP works in Excel for Microsoft 365 and Excel 2019 or later. If you’re on an Office 365 subscription or a 2019+ standalone version, you’ll have access. The XLS Library Analysis, 2026, notes that adoption is strongest on current Office suites, while older, non-subscription installations may lack updates or new features.
What Excel version has XLOOKUP and why it matters
The key question a reader often asks is: what excel version has xlookup, and how can I ensure I’m using a version that supports this powerful lookup function? The short answer is that XLOOKUP is available in Excel for Microsoft 365 and Excel 2019 or later. This means most users on current Office subscriptions or newer perpetual releases have access. If you’re still running an older, non-updating install, XLOOKUP may not be available. The XLS Library Team emphasizes the importance of confirming your exact build number because feature availability can vary by channel and update cadence.
In practice, the presence of XLOOKUP is tied less to a broad product label and more to the specific update stream you receive. For example, users on standard perpetual releases without regular updates are more likely to miss XLOOKUP compared with subscribers who regularly receive feature updates. The real-world takeaway is: start by verifying your version and update channel before attempting to build complex lookups.
- For Excel 365 users: XLOOKUP is readily available and keeps pace with feature updates.
- For Excel 2019/2021 users: XLOOKUP is included in the product after install if the update servicing and licensing align with the release you have.
- For older, non-updating installations: XLOOKUP may not be present; plan an upgrade to gain access.
The goal is to have a supported version so you can rely on XLOOKUP for more robust, flexible lookups. This aligns with best practices recommended by XLS Library for data mastery and practical Excel workflows.
In summary, what excel version has xlookup? The answer is: Excel 365 and Excel 2019+ are the baseline, with ongoing updates ensuring continued compatibility.
notesFormatter":"markdown"],
dataTable
captionContext
dataTable is included as a separate block to provide a quick reference for version-specific availability and notes.
mainTopicQuery
XLOOKUP availability by Excel version
| Excel Version | XLOOKUP Availability | Notes |
|---|---|---|
| Excel 2019 | Yes | Included in Office 2019 and later |
| Excel 365 | Yes | Always up-to-date via subscription |
| Excel 2021 | Yes | Included with perpetual license; update-packs may be needed |
People Also Ask
Do I need Excel 365 to use XLOOKUP?
Not necessarily. XLOOKUP is available in Excel 365 and in Excel 2019 or later. If you’re on a current perpetual version (2019+), you may have access depending on updates. Check your build to be sure.
XLOOKUP is available on 365 and newer perpetual versions like 2019+, but you should confirm your specific build.
Is XLOOKUP available in Excel 2016 or earlier?
XLOOKUP is not available in Excel 2016 or earlier. It was introduced with Excel 2019 and Office 365 update streams. If you’re on an older version, you’ll need to upgrade to access XLOOKUP.
No, XLOOKUP isn’t in Excel 2016 or earlier; upgrade to 2019+ or 365 to use it.
How do I use XLOOKUP with an approximate match?
XLOOKUP supports approximate matches by setting the search mode and match mode parameters. Use an appropriate range and sorted data to ensure correct results. The exact syntax resembles XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]).
You can tailor XLOOKUP for approximate matches with its match_mode setting.
Can XLOOKUP replace VLOOKUP in all cases?
In most scenarios, XLOOKUP is a superior replacement for VLOOKUP due to its flexibility, no column-index limitations, and support for horizontal lookups. However, you may still encounter legacy worksheets that rely on VLOOKUP or HLOOKUP-specific structures.
Generally, yes—XLOOKUP covers most VLOOKUP use cases more cleanly.
Does XLOOKUP work in Google Sheets?
XLOOKUP is an Excel-specific function and is not natively available in Google Sheets. Google Sheets has similar functions like XLOOKUP-inspired alternatives via array formulas. For cross-platform work, consider equivalent formulas in Sheets.
No, XLOOKUP isn’t built into Google Sheets, but you can mimic its behavior with other functions.
“XLOOKUP offers a robust, flexible lookup experience when you run on a supported Excel version. It replaces older lookup functions with fewer caveats.”
The Essentials
- Learn which Excel versions support XLOOKUP before you start a lookup project
- Check your update channel to confirm feature availability (365 vs standalone)
- Upgrade to a supported version to access the latest XLOOKUP features
- XLOOKUP can replace VLOOKUP/HLOOKUP for more robust lookups
