Try a wildcard like

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

If this post helps click Yes
---------------
Jacob Skaria


"Scarlett" wrote:

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?