Forum Discussion
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.156...
I'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.
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.
Thank you for help.
I use the first method and it works.
I use the first method and it works.