Office Compatibility Issues

Are XLOOKUP and XMATCH Available in Excel 2019?

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user wants to know whether XLOOKUP and XMATCH are available in the perpetual version of Excel 2019.

Are XLOOKUP and XMATCH Available in 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.
Before you start

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.

Solution 1Recommended

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.

1
Confirm your version

Open Excel and select File > Account to check the product name under Product Information.

2
Check current availability

Visit Microsoft Support and search for “XLOOKUP function” and “XMATCH function” to review the versions listed for each function.

3
Open the workbook in a supported version

Use Excel for Microsoft 365, Excel 2021, or Excel 2024 to open the workbook and enter or recalculate XLOOKUP and XMATCH formulas.

Use a Supported Version of Excel for XLOOKUP and XMATCH
Perpetual license option: A newer perpetual version such as Excel 2021 or Excel 2024 can provide these functions without a Microsoft 365 subscription.
Free Microsoft Office alternative

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.

Use familiar spreadsheet tools for lookup tasksOpen and edit Microsoft Excel XLSX filesMove existing workbooks into a familiar interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

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.