Forum Discussion
XLOOKUP returning #N/A for some values when the values are there
I am trying to use XLOOKUP to find an identifying number from a separate spreadsheet, referenced by a different identifying number. My equation works for the most part, but I have a few #N/A errors (...
jgans The LOOKUP functions are sensitive to the data-type on both ends. They will only find a match if both the looked for cell and the Looked In range contain numeric, or text values. If the data types do not match up, no match is found.
So check your data in the table you are looking up information from, some ID's are text and others are numbers. You want all of them to be text, or all of them numbers. And the cell containing the lookup ID to be of the same data type.