How to Install XLOOKUP in Excel and Check Compatibility

You do not install XLOOKUP as a separate Excel feature or add-in: it is already built into supported versions. To use it, open Microsoft 365 or Excel 2021 or later, update Excel if needed, and enter an XLOOKUP formula in a worksheet. If you use Excel 2019 or 2016, updating that version will not add XLOOKUP; you will need a supported version or a different lookup method.

What You’ll Need

A supported version of Excel: Microsoft 365, Excel 2021, or Excel 2024. XLOOKUP is also available in Excel for the web.
A workbook containing a value to search for and the related values you want returned. A small test table is useful for checking that the function works.
Internet access if you need to download an Office update. On a work or school computer, your administrator may control when updates are installed.

Step-by-Step

Check which Excel version you have. In Excel for Windows, open Excel and choose File > Account. Look under Product Information for your product name and subscription status. Choose About Excel on that page if you need the detailed version and build number. On a Mac, open Excel and select Excel > About Microsoft Excel. In Excel for the web, sign in at Microsoft 365 and open the workbook in your browser; the web app is updated by Microsoft rather than through a desktop update button. Confirm that the desktop edition is Microsoft 365, Excel 2021, or Excel 2024. Excel 2019 and Excel 2016 do not support XLOOKUP, even if you install their latest updates.
Save your work and close files you do not need. An Office update normally preserves your workbooks, but saving first is a sensible precaution. Close Excel files that are being edited by other people or that contain unsaved changes. If you use a work-managed computer, check your organization’s update policy before trying to change the installation.
Update Excel on Windows if it is supported but out of date. In Excel, select File > Account. Under Product Information, select Update Options > Update Now. If Excel asks you to close Office apps, save your work and close them so the update can finish. Wait for the update process to complete, then reopen Excel. The exact timing and available update options can vary because Microsoft 365 updates are delivered in stages and organizations can defer them.
Update Excel on a Mac if needed. In Excel, select Help > Check for Updates to open Microsoft AutoUpdate. Follow the on-screen instructions to install available updates, then reopen Excel. If you installed Office through the Mac App Store, update it through the App Store instead. Excel for the web does not have a manual update command; refresh the browser or sign out and back in if the app appears stale.
Make a simple test table. In a blank worksheet, put product codes in A2:A6, corresponding product names in B2:B6, and prices in C2:C6. For example, A4 can contain P-103 and C4 can contain 12.50. Put the code P-103 in E2. This arrangement gives Excel a search column, a return column, and a lookup value, so you can tell whether the function is returning the intended result.
Enter and check a test XLOOKUP. With product codes in A2:A6, names in B2:B6, prices in C2:C6, and the code to find in E2, enter this in F2 to return the matching price: =XLOOKUP(E2,A2:A6,C2:C6,"Not found"). Because E2 contains P-103 and the matching price in C4 is 12.50, F2 should display 12.50. The formula searches A2:A6 for the value in E2 and returns the value from the same relative position in C2:C6. The text in quotation marks is an optional message to show when there is no match; it is not an Excel installation setting.
Use XLOOKUP in your own workbook. Replace the sample lookup value and ranges with the cells in your sheet. Select the cell where you want the answer, type the equals sign followed by XLOOKUP, and provide the lookup value, the one-column or one-row lookup range, and the corresponding return range. Press Enter. You can also type =XLOOKUP( and select cells with the mouse; Excel shows the function argument hints as you enter the formula. Check that the result matches a known record before copying the formula to other rows.
Save the workbook after checking the result. Save the file in a format your colleagues can open, such as the standard .xlsx format. A formula using XLOOKUP will not calculate in unsupported older Excel editions, so confirm the recipients’ software supports it if the workbook will be shared. If they use an older version, consider replacing the formula with a compatible approach or providing a static copy of the results.

Those steps make XLOOKUP available by confirming that Excel supports it and updating a supported installation. There is no XLOOKUP download, installer, or separate add-in to enable. The function is a built-in worksheet function, so once Excel recognizes it you can use it in any suitable workbook without turning on a ribbon option.

Common Mistakes

Looking for an XLOOKUP add-in. XLOOKUP is not installed from the Office Store or enabled through Excel Add-ins. Searching for an add-in with that name is unnecessary; check your Excel version instead.
Assuming an update adds the function to any version. Updates fix or improve a supported release, but they do not convert Excel 2016 or 2019 into Microsoft 365 or Excel 2021. If you have an unsupported version, the remedy is a supported Excel edition or another formula, not repeated updating.
Using mismatched lookup and return ranges. The search and result ranges should cover corresponding records in the same order. If the lookup range starts at row 2 but the return range starts at row 3, Excel can return a value from the wrong record. Keep the ranges aligned and check their first and last rows.
Expecting a match when the values differ. A number stored as text may not behave like a numeric value, and leading or trailing spaces can prevent a text match. Compare the source and search value, including spaces and data type, before assuming that XLOOKUP is missing.
Entering the arguments in the wrong order. XLOOKUP needs the value to find, the range to search, and the range to return from, in that order. Selecting the return column as the lookup range can produce an error or an unintended result.
Mixing up an unavailable function with a missing result. A message such as “Not found” means Excel evaluated the formula but did not find the search value in the selected range. A #NAME? error usually means Excel does not recognize the function name, which can indicate an unsupported version, a misspelling, or a localized function name.

Tips

Check the edition as well as the update status. “Up to date” does not necessarily mean a copy of Excel supports every newer function. The product name and release matter. Microsoft 365 is continually updated, while perpetual versions have a defined feature set.
Use the function hints. After typing XLOOKUP and an opening parenthesis, Excel displays the expected arguments. This can help you distinguish the search range from the return range and avoid a syntax error.
Start with a short, known example. Test one value whose matching row and expected answer you can identify. When that succeeds, use the same range logic on the full dataset. This separates a version problem from an issue with the layout or contents of your real data.
Keep related columns together and consistent. If product codes are in one column and prices in another, make sure each row describes the same product. Sorting both columns together is safe; sorting only one can break the relationship between codes and results.
Use a clear not-found message when appropriate. The optional fourth argument in the test formula can make missing matches easier to spot than an error. Choose a message that makes sense for your workbook, and do not use a blank result if readers need to know that a match was absent.
Ask your administrator about managed updates. If Update Options is missing or disabled, the computer may be managed by an employer or school. An administrator may use a deployment schedule or an update channel that controls which features are available. Do not try to bypass those controls.

Troubleshooting

Excel says the function is not valid or shows #NAME?. Recheck the product name in File > Account on Windows or Excel > About Microsoft Excel on Mac. If the installed release is Excel 2016 or 2019, XLOOKUP is not supported there. If you have Microsoft 365 or Excel 2021 or later, install any available updates and restart Excel. Also check the spelling and whether your language settings require a localized function name or a different argument separator.

The formula shows “Not found.” Confirm that the lookup value actually exists in the selected search range. Check for extra spaces, inconsistent punctuation, and numbers stored as text. Make sure the formula points to the correct worksheet and that the lookup and return ranges include the row you expect. If the value is not in the source data, the message is the expected result rather than evidence that XLOOKUP failed to install.

The answer comes from the wrong row. Inspect the start and end of both ranges and make sure they cover the same records in the same order. For example, if the code range excludes a header and begins at row 2, the return range must also begin at the corresponding row 2. Avoid including a title or subtotal in only one range.

Update Now is unavailable or updates do not appear. Check whether your organization manages Office updates, and ask its help desk or administrator if necessary. On a Mac, make sure Microsoft AutoUpdate is available, or use the Mac App Store if that is where Office was installed. On the web, refresh the page and reopen the workbook. If the desktop product remains unsupported, an update will not make XLOOKUP available; use a supported release or a compatible alternative.

The formula is visible as text instead of calculating. Check whether the cell is formatted as Text. Change its number format to General, then re-enter the formula in the cell. Also make sure there is no apostrophe before the equals sign. If calculation is set to manual, choose Formulas > Calculation Options > Automatic on the Windows ribbon, then recalculate the workbook.

You see a spill error or an unexpected blank. If a formula is meant to return multiple values, make sure the cells where those results need to appear are empty and not merged. For the single-price test above, check that you selected one return column and one lookup value. If a cell is blank in the source table, XLOOKUP can correctly return a blank for that matched record.

Frequently Asked Questions

Do I need to download or install XLOOKUP separately?
No. It is built into supported Excel versions. Update a supported desktop version if needed; there is no separate XLOOKUP installer or add-in.

Which Excel versions include XLOOKUP?
XLOOKUP is available in Microsoft 365, Excel 2021, Excel 2024, and Excel for the web. Excel 2019 and Excel 2016 do not support it. Check the exact product name, not just whether Office reports that it is up to date.

Can I add XLOOKUP to Excel 2019 with an update?
No. Regular updates do not add XLOOKUP to Excel 2019 or 2016. You need to use a supported version of Excel or choose a lookup method that works in your existing version.

Does XLOOKUP work on Mac and in a browser?
Yes, in supported versions. On Mac, install available Office updates through Microsoft AutoUpdate or the Mac App Store, depending on how Office was installed. Excel for the web updates automatically and does not use the desktop Update Now command.

Why does XLOOKUP work on my computer but not for someone else?
The other person may be opening the workbook in an older Excel release that does not recognize the function. Ask which version they use. They can use a supported version, or you can provide a compatible formula or a separate copy containing static results.

Is XLOOKUP part of Excel’s Analysis ToolPak?
No. The Analysis ToolPak is an optional add-in for certain analysis tools; XLOOKUP is a worksheet function built into supported Excel versions. Enabling the ToolPak will not make XLOOKUP available in an unsupported edition.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.