Forum Discussion
XLOOKUP Doesn't work
The XLOOKUP not working is also new to me.
But have you tried the other lookup functions?
Does this problem only occur in this file or in all files?
In which medium is the file?... on OneDrive, Sharepoint or hard drive.
For example if on OneDrive, tried downloading and pasting again?
Do they all have the same operating system installed?
Are other users using Excel for Web?
Many questions arise because no further information is available.
If none of this is the case
You can try the following
Install the latest update
Repair Office programs
Start Office applications in safe mode
Identify possible problems with the add-in
Check if the file was created by a third party
Please don't forget that not every Excel user has a clue about every job and… what you see he can't see.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)