Forum Discussion

timm1216's avatar
timm1216
Copper Contributor
Dec 05, 2018
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!

 

But, when I double click on one of the cell contents, the data shifts to the right of the cell at which point it presto! The cell data becomes "matchable".

 

So, when the data is brought in from Sharepoint, it is in a state where I can't MATCH the data in a cell. 

 

Anyone have any ideas ?

 

 

BI & Data Analytics
Need Help
  • jimfikes's avatar
    jimfikes
    Dec 05, 2018

    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.

2 Replies

Sort By
  • jimfikes's avatar
    jimfikes
    Copper Contributor
    Dec 05, 2018

    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.

    • timm1216's avatar
      timm1216
      Copper Contributor
      Dec 05, 2018

      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 :)

Resources