Fix Missing SEQUENCE and XLOOKUP Functions in Excel 2019
Question details
Users are unable to find or use the SEQUENCE and XLOOKUP functions in Microsoft Excel 2019.
- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- Attempting to use newer dynamic array or lookup functions in Excel 2019 spreadsheets.
- Observed behavior
- The SEQUENCE and XLOOKUP functions return a #NAME? error or are completely absent from the formula autocomplete list.
Verify your exact version of Microsoft Office by navigating to File > Account in Excel, as these specific dynamic array functions are highly version-dependent.
Upgrade to Microsoft 365 or Office 2021
The most direct way to access SEQUENCE, XLOOKUP, and other modern dynamic array functions is to use a supported newer version of Office.
Microsoft introduced dynamic array functions and XLOOKUP after the release of Excel 2019. Because Excel 2019 is a perpetual license without feature updates, these functions are only available in Microsoft 365 or perpetual versions from Office 2021 onwards.
Open Excel, click on 'File', and select 'Account' to confirm you are using Excel 2019.
Purchase a Microsoft 365 subscription or a perpetual license for Office 2021 (or later).
Download and install the new software from your Microsoft account dashboard to unlock the missing dynamic array functions.
Use Alternative Formulas in Excel 2019
Replicate the behavior of XLOOKUP and SEQUENCE using older, supported functions like INDEX, MATCH, and ROW.
Use WPS Office to Access Advanced Functions for Free
WPS Spreadsheet is a powerful, lightweight, and free alternative to Microsoft Excel. It features robust support for modern formulas—including XLOOKUP—ensuring seamless compatibility with advanced files without requiring expensive subscriptions.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file.
- 3. Use advanced formulas: Type =XLOOKUP or other advanced functions directly into the cell; WPS will calculate them seamlessly.
Frequently Asked Questions
Can I download an update for Excel 2019 to include XLOOKUP?
No, Microsoft does not add new functions to perpetual license versions like Excel 2019 after their initial release. You must upgrade to Office 2021 or Microsoft 365 to natively access XLOOKUP.
Why does my XLOOKUP formula show a #NAME? error in Excel 2019?
The #NAME? error occurs because Excel 2019 does not recognize the XLOOKUP function. To fix this, you will need to rewrite the formula using the INDEX and MATCH combination, or open the document in a supported application.
Are there any official add-ins to get SEQUENCE in Excel 2019?
There are no official Microsoft add-ins that enable dynamic array functions like SEQUENCE natively in Excel 2019. You must rely on alternative formula combinations or VBA scripts as a workaround.
