XLOOKUP Function Disappeared

I have been using xlookup for several months across several files just fine but today it stopped working across all Excel files. I invested a lot of effort moving from vlookup to xlookup and now it's all broken. It returns the error "#NAME?" and it looks like the function is missing in the formula builder. How do I add the function?

2

1 Answer

XLookup is only part of Office365 subscriber licenses. If you have switched to a different license, or somehow your office is not activated anymore, you will lose a few Office365 only functions too, including xlookup.

If your license is still valid, try to repair your office installation or update it.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy