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...
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.