xlookup issue

Occasional Contributor

Excel =XLOOKUP Formula is not working in German nor English version. It is not even being recognised as a function. Already tried to reinstall and update Office and still the issue persists - please see reference number 1018036622.

7 Replies

@MoselRheiderland MS support writes the following with regard to XLOOKUP.

Screenshot 2021-02-23 at 12.47.20.png

Are you using Excel for MS365 for Mac? If not, that's why you don't have it.

@Riny_van_Eekelen Well, I bought an MS365 licence and have an annual subscrition plan. I downloaded the installation files via the "Download Office"-Button at office.com while I was logged in, so I assumed it had to be the MS365 version. If I go to Excel > Info it says "Microsoft Excel für Mac" and "Version 16.46" which is the most recent as far as I know. So it should be MS365, shouldn't it?

Is there any other reliable way to check, what exact product I am currently using?

@MoselRheiderland Perhaps dumb suggestion, but did you try XVERWEIS ?

@Riny_van_Eekelen Yes, I have

I also used the function generator to look for it in case I misspelled something, but it doesn't show the function, neither in german nor in english.



In the Help meny, Check for updates. Then "Advanced". Which channel are you on (Current, Current Preview or Beta). I'm running Excel on different Mac, both in Current and Beta channel. Both have =XLOOKUP since several months ago. You should have it also.

@Riny_van_Eekelen Strange indeed. There are no updates available, it is running the newest version and the Update Channel is "Current".

I also have the feeling, nobody else seems to have this problem. This usually indicates I made a very obvious mistake, but I just cannot find it. The MacOS I'm running it on is Catalina 10.15.7 (minimum is Mojave 10.14) so that isn't the problem either...

@Riny_van_Eekelen The problem has been solved! Our Technician suggested using an app cleaner to deinstall the current office installation completely and reinstall it via the AppStore instead of downloading the installation file and IT WORKED. The layout has changed slightly and the XVERWEIS function is available.


Thank you very much for your help and suggestions in the process!