How to Fix XLOOKUP Missing in Excel 365 on Mac
Question details
The user is unable to access or use the XLOOKUP function in Microsoft Excel 365 on a Mac, despite having an updated application.
- Product
- Microsoft Excel 365
- Device & OS
- Mac
- Scenario
- Attempting to perform data lookups using the XLOOKUP function in an up-to-date installation of Excel.
- Observed behavior
- The XLOOKUP function is missing or unrecognized by the software, even though version 16.74 is installed on the Mac.
Ensure that your Microsoft 365 subscription is active and that you are signed in with the correct Microsoft account, as XLOOKUP requires an active subscription or an Excel 2021 (or newer) license to function.
Restart Mac and Verify Excel License Type
Restarting your Mac can help finalize recent Office updates, and verifying your license ensures your account actually supports dynamic array functions like XLOOKUP.
Sometimes Excel features do not fully activate until the system is restarted after an update. Additionally, if your software is logged into a perpetual license (like Office 2019) instead of a Microsoft 365 Subscription, newer features like XLOOKUP will remain permanently hidden regardless of the app version.
Save any open work and completely restart your Mac to ensure all recent Microsoft 365 updates and background services are correctly applied.
Open Excel. In the top Apple menu bar, click on 'Excel' and select 'About Microsoft Excel'.
Look at the 'License' field in the pop-up window. It must say 'Microsoft 365 Subscription'. If it shows an older perpetual version, XLOOKUP will not be available.
Type '=UNIQUE(' or '=XMATCH(' into an empty cell. If these functions are also missing, your current license or local activation does not support modern dynamic arrays.
Use XLOOKUP Immediately in WPS Spreadsheet
If Microsoft Excel is experiencing licensing errors or update glitches on your Mac, you can bypass the issue completely using WPS Office. WPS Spreadsheet fully supports XLOOKUP and handles your Excel files natively without complex subscription hurdles.
- 1. Install WPS Office: Download and install the free WPS Office application for Mac from the official website.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx document.
- 3. Select the Target Cell: Click on the specific cell where you want your lookup results to appear.
- 4. Enter the XLOOKUP Formula: Type '=XLOOKUP(' and select your lookup value, lookup array, and return array.
- 5. Execute the Function: Press Enter to instantly retrieve your data without any license activation delays.
Frequently Asked Questions
Can I download XLOOKUP separately if it is missing?
No. XLOOKUP is a built-in function in Microsoft 365 and Excel 2021 or newer. It is not available as a standalone add-in or downloadable package.
Why does my Excel say it is up to date but still lacks XLOOKUP?
Even if the application software is updated to the latest version (like 16.74), feature availability is dictated by your license type. If you are signed in with an Office 2019 license, XLOOKUP will remain disabled.
What is a good alternative formula if XLOOKUP is unavailable?
If you cannot access XLOOKUP, you can use a combination of the INDEX and MATCH functions, which are available in all older versions of Excel and provide similar flexible lookup capabilities.
