Are XLOOKUP and XMATCH Available in Excel 2019?
Question details
The user wants to know whether XLOOKUP and XMATCH are available in the perpetual version of Excel 2019.

- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- A user wants to use newer lookup functions without subscribing to Microsoft 365.
- Observed behavior
- The user needs to determine whether Excel 2019 supports the functions and what alternatives are available.
In Excel, open File > Account and check the product name to confirm which version you have. Identify any formulas that use XLOOKUP or XMATCH so you can test suitable alternatives.
Use a Supported Version of Excel for XLOOKUP and XMATCH
Choose this option if you need the functions themselves rather than substitute formulas.
XLOOKUP and XMATCH are not available in Excel 2019. They are available in Microsoft 365 and newer perpetual versions, including Excel 2021 and Excel 2024.
These functions were initially introduced to Microsoft 365 subscribers; joining an Insider program does not add them to Excel 2019.
Open Excel and select File > Account to check the product name under Product Information.
Visit Microsoft Support and search for “XLOOKUP function” and “XMATCH function” to review the versions listed for each function.
Use Excel for Microsoft 365, Excel 2021, or Excel 2024 to open the workbook and enter or recalculate XLOOKUP and XMATCH formulas.

Replace Simple Lookups with INDEX and MATCH in Excel 2019
Use existing Excel 2019 functions when you need an exact-match lookup without upgrading.
Work with Lookup Formulas in WPS Spreadsheets
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open Excel files and use compatible lookup formulas as you move between office suites; it does not add functions to Excel 2019.

Frequently Asked Questions
Can an Excel 2019 update add XLOOKUP or XMATCH?
Excel 2019 does not support these functions. To use them, open the workbook in a supported version such as Excel for Microsoft 365, Excel 2021, or Excel 2024.
What can I use instead of XLOOKUP in Excel 2019?
For a basic exact match, enter an INDEX and MATCH formula such as =INDEX(B2:B100,MATCH(E2,A2:A100,0)) in the result cell. Adjust the ranges to fit your data.
Is there an alternative to XMATCH in Excel 2019?
Use MATCH for a basic position lookup. For example, =MATCH(E2,A2:A100,0) returns the position of the first exact match within the specified range.
Will a workbook with XLOOKUP formulas work in Excel 2019?
Excel 2019 cannot calculate XLOOKUP formulas. Open the workbook in a supported Excel version or replace the formulas with compatible alternatives such as INDEX and MATCH.




