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?