Fix XLOOKUP Missing in Excel for Mac with a Work Account
Question details
The user is unable to access or use the XLOOKUP function in Excel for Mac after signing in with an employer-provided Microsoft 365 work account.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Using advanced spreadsheet functions under an employer-provided Microsoft 365 subscription on a Mac device.
- Observed behavior
- The XLOOKUP function is completely missing or unrecognized by the software, despite being available previously or under a different Microsoft account.
Verify that your work account's assigned license includes Microsoft 365 Apps for enterprise or business, as some corporate volume licenses (like Office 2019 Standard) do not support the XLOOKUP function.
Verify Your Office License and Update Excel
Use this method to confirm whether your employer's assigned license supports XLOOKUP and to ensure you are running the latest version of Excel for Mac.
XLOOKUP is exclusively available for Microsoft 365 subscribers and Office 2021 users. If your work account assigns an older one-time purchase license, the function will not be available.
Open Excel on your Mac. In the top menu bar, click on 'Excel' and select 'About Microsoft Excel'. Look at the 'License' field to ensure it says Microsoft 365 Subscription.
Click on 'Help' in the top menu bar and select 'Check for Updates'. Follow the prompts in Microsoft AutoUpdate to install the latest software updates for Excel.
Fully quit Microsoft Excel and reopen it. Type '=XLOOKUP' in any cell to see if the function is now recognized.
Reinstall Microsoft 365 Apps for Mac
If your license is valid and Excel is up to date but XLOOKUP is still missing, reinstalling the application can resolve underlying installation corruption.
Use WPS Office as a Free Alternative with Full XLOOKUP Support
If your employer's Microsoft license doesn't support the latest features or you are frustrated with missing functions in Excel for Mac, switch to WPS Office. It provides robust spreadsheet tools, native support for advanced functions like XLOOKUP, and a lightweight experience without enterprise license headaches.
- 1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Install and open: Run the installer package and launch WPS Spreadsheets on your Mac.
- 3. Use XLOOKUP instantly: Open your existing .xlsx file and start using the XLOOKUP function right away without checking complicated license requirements.
Frequently Asked Questions
Why is XLOOKUP suddenly missing in my Excel for Mac?
This typically happens if your Excel version was downgraded, your Microsoft 365 subscription expired, or you switched to a work account with an older volume license (like Office 2019) that does not support the XLOOKUP function.
Does XLOOKUP work on Office 2019 for Mac?
No, XLOOKUP is not available in Office 2016 or Office 2019. It is only supported in Microsoft 365 subscriptions and Office 2021 or newer standalone versions.
How do I check which Excel license my Mac is using?
Open Microsoft Excel, click on 'Excel' in the top left corner of the menu bar, and choose 'About Microsoft Excel'. The dialog box will display your current software version and license type.
Will my Excel files break if XLOOKUP is missing?
If you open a workbook containing XLOOKUP in a version of Excel that doesn't support it, the formula will return a #NAME? error until it is opened in a supported version or an alternative like WPS Office.
