XLOOKUP formula not working

Copper Contributor

Hello

 

I'm having trouble with the XLOOKUP formula, my excel doesn't show that it has this formula. I have the newest version of excel and the formula worked perfect on my other computer - windows and now I have Mac Air. I transferred all the files and nothing is working.

 

The formula

=XLOOKUP(A3;Toiduained!A:A;Toiduained!B:B;)
and shows error #NAME?

 

How can i get XLOOKUP formula on my excel?

 

 

3 Replies

@indraottis Well, if you really have Excel for MS365 or Excel 2021 on your Mac, it should work just the same as on a PC with those versions. Are you sure the Mac is running one of the versions mentioned?

@Riny_van_Eekelen Thank you for the answer, I have excel verison 16.85, what should be the most current. Talked to two IT guys also and they say'd they don't know what's the problem.

@indraottis 

Does your Mac run English Excel? Create a file on a PC that supports XLOOKUP. Save it and open it on your Mac. If it's just a language issue  Excel automatically translates the function name. If not you'll get a NAME error.