Forum Discussion
ACGG12340
Oct 13, 2020Copper Contributor
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...
Detlef_Lewin
Oct 13, 2020Silver Contributor
All lookup functions require the same datatype for matching.
Use ISNUMBER() or ISTEXT() to verify that the cells have the same datatype.