Forum Discussion
XLOOKUP formula not working
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...
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.
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.