Forum Discussion
XLOOKUP Error - Need Help
Hi, I have two different sheets. On Sheet A I want to look up and return a value from Sheet B. The unique identifier exists within both sheets. I can literally see the value I want to reference i...
All lookup functions require the same datatype for matching.
Use ISNUMBER() or ISTEXT() to verify that the cells have the same datatype.