Forum Discussion
PSMCToday
Jan 12, 2019Copper Contributor
VLOOKup confusing the data
Hi, I just ran a VLOOKUP to a list of 40K+ items to match a ZIP code to a county. It did pull all the ZIP codes I requested but several do no match the correct county. Not sure what I did wrong. ...
Eva Vogel
Jan 13, 2019Iron Contributor
Hi!
Would be interesting, in which context you did it successfully and at what first line it did not. Can you pls. offer a screenshot of the source and which line you doubt in your excel table? Otherwise it is a little bit obscure what could be the case.
Plausible cause could be: CHeck your ZIP source if this column is ONLY and all content in same TEXT data type. In Germany we use TEXT data Column as to "DE-80801" for Munich-Schwabing as an example.
Have a good weekend! Greets, Eva.
Greets, Eva.