Forum Discussion
Aperru
Sep 20, 2022Copper Contributor
XLOOKUP or XMATCH functions not available with EXCEL 2021
Hi all,
I have Excel 2021 LTSC and i try to use XLOOKUP and XMATCH and they are not reconized.
My version displayed in File>Account>About Excel is :
Microsoft Excel MSO Version 2208 Build 16.0.15601.20148 64 bits
Any Idea ?
regards
3 Replies
Sort By
- Patrick2788Silver ContributorI've seen this crop up a few times with various versions of Office.
There's a few things you can try. I'd try it in this order:
1. Log out/in of your account through File | Account
2. Repair Office (I believe you'd get the MSI-based repair options).
Reference on repairing: https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b#:~:text=How%20to%20Repair%20My%20Office%201%20Right-click%20the,screen%20to%20complete%20the%20repair.%20.%20See%20More.- Huang1175Copper ContributorThank you for help.
I use the first method and it works. - AperruCopper Contributor
Patrick2788
Hi,
Many thanks for your help !
I tried both 1/ and 2/ without success 😞
According to the refrenced doc the next step sould be to completely uninstall Office and then reinstall it...