Vlookup function across data copied from various sources
 

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?

Vlookup function across data copied from various sources
 

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 - D1:D100?

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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