Vlookup function wont work for copied data

[Scarlett]

I have copied a table from another source. I am trying to do a vlookup for a
column against this copied table. However N/A is returned. I tried TRIM,
CLEAN, nothing works.

I re-entered a couple of entries of the table and the vlookup function
worked fine. However is there a logic to this problem and how do I make sure
that the vlookup works for the entire column?

 

[Jacob Skaria]

Try a wildcard like

=VLOOKUP("*" & lookupvalue & "*",array,column,type)

If this post helps click Yes

 

[Gord Dibben]

The other source is what?

You could have some non-breaking spaces which CLEAN and TRIM won't find.

Edit>Replace

What: Alt + 0160

With: nothing

Replace all.

Note: hold the Alt key and type 0160 on the NumPad, not above the qwerty
keys.

If no joy go to Chip Pearson's site and download his cellview add-in to find
out what's in the cells.

http://www.cpearson.com/excel/CellView.aspx

An indispensable tool if bringing in data from the Internet



Gord Dibben MS Excel MVP