Forum Discussion
Solved
I can't find a MATCH in a column imported from a Sharepoint List
Hi - I'm scratching my head on this one ... I pulled in a sharepoint list into an excel file (see attached) and stored it as a table. And, I can't MATCH any of the values on a lookup! ...
The data in your file is text, not numbers. Were you expecting to find a number? If so, then you need to convert those values from text to number format.
The data in your file is text, not numbers. Were you expecting to find a number? If so, then you need to convert those values from text to number format.
I see ...
The format of the data I was attemting to match was "General".
When I changed it to text, I was able to find the match.
Also, I see that when I double clicked the cell, it actually converted the format to a number.
Thanks for the tip. That's all I needed :)
