Vlookup function across data copied from various sources

[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?

 

[Shane Devenshire]

Hi,

Really should show us the formula, what the data in the lookup table looks
like and what the data you are looking up is, in otherwords in the formula
=VLOOKUP(A1,D1:M100,3,FALSE)
What is in A1, what is in the 3rd column of the range D1:M100?, what is in
the 1st column of that range - D1100?

Most of the time N/A means that the function failed to find the item you
were looking up.