Function Problems

How to Fix Cannot Find or Use XLOOKUP in Excel 2021 or Microsoft 365

Maira Mehtab Sep 20, 2026 871 views

Question details

The user is unable to locate or use the XLOOKUP function in Microsoft Excel despite believing they are using version 2021 or Microsoft 365.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use the XLOOKUP function for data retrieval in a spreadsheet.
Observed behavior: The XLOOKUP function is unavailable, unrecognized, or returns an error, possibly due to an underlying version conflict or a missing software update.

Before you start

Ensure your computer is connected to the internet and you have your Microsoft account login credentials handy, as you may need to verify your license or download updates.

Solution 1Recommended

Verify Your Exact Excel Version and Build

XLOOKUP is only available in Microsoft 365 and Office 2021 or newer. Verifying your exact product information helps determine if your current installation actually supports the function.

Sometimes, a computer may have multiple versions of Office installed, or a Microsoft 365 subscription may have lapsed, causing Excel to revert to an older license like 2019 where XLOOKUP is not supported.

Open Excel

Launch the Microsoft Excel application and open any blank workbook.

Access the Account Menu

Click on 'File' in the top-left corner of the ribbon, then select 'Account' from the bottom of the left-hand menu.

Check Product Information

Look under the 'Product Information' section on the right side to confirm your exact product name (e.g., Microsoft 365 Apps or Office 2021).

Find Build Number

Click the 'About Excel' button to see your specific version and build number. If it says 2019 or older, XLOOKUP is not supported.

Provide Details for Support: If you are seeking help on a Microsoft forum, take a screenshot of this Account page (hiding your email address) to show your exact version.

Solution 2

Update Microsoft Office to the Latest Version

If you have a supported version like Microsoft 365 but still cannot see XLOOKUP, your software might be missing the latest feature updates.

Free Microsoft Office alternative

Use WPS Office to Enjoy Advanced Spreadsheet Functions

If you are stuck on an older version of Excel or dealing with subscription licensing issues that prevent you from using XLOOKUP, consider switching to WPS Office. It provides powerful spreadsheet features, high compatibility with standard formats, and a familiar interface—completely free.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files directly without losing any data or formatting.
3. Use Lookup Functions: Start using powerful lookup and data analysis functions exactly as you would in standard spreadsheet software.

Supports advanced lookup and reference functions for complex data tasks.Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight installation that runs smoothly without expensive subscriptions.Familiar and intuitive interface makes switching fast and effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a #NAME? error when I type XLOOKUP?

The #NAME? error occurs when Excel does not recognize the function name. This usually means you are using a version of Excel (like Excel 2016 or 2019) that does not support XLOOKUP, or your Microsoft 365 account requires a license refresh.

Is XLOOKUP available in Excel 2019?

No, XLOOKUP is not available in Excel 2019 or earlier standalone versions. It was introduced in July 2020 and is only included in Microsoft 365 subscriptions and standalone versions from Excel 2021 onwards.

What can I use if XLOOKUP is missing?

If XLOOKUP is unavailable, you can use traditional lookup methods such as combining the INDEX and MATCH functions, or using VLOOKUP and HLOOKUP, to achieve similar data retrieval results.

Excel & Data Problems