Forum Discussion
VLOOKUP not returning values with information copied from the internet
I am trying to use a VLOOKUP function with data copied from the internet. I've seen similar posts about this where the solution was to paste special and choose values. This is not working. Please hel...
Quite often when data copy/pasted from the web it includes not-breaking space (UNICODE 160), perhaps some other not printable characters.
You may check in any empty like =cell1=cell2 if lookup value is really is the same. Or check by =LEN(cell) it returns exact number of visible character.
If so you need to clean pasted data. However, that could be other reasons, better to check on sample file if you could provide it.