Hi,

I think that the cell that contains the reference is formatted as text.
Change it to number.

Or, modify the VLOOKUP formula as follows:
=VLOOKUP(A1*1,lookuprange, ) where A1 is the reference cell. The
"A1*1" in the formula will treat the text in A1 as a number.

Please click "Yes" if the solves your problem.

Regards,
B. R. Ramachandran

"Bob1866" wrote:

Hi, If I type a value into the cell which is the reference for the Vlookup i
get the error "#N/A" yet if i copy and paste the same number from the lookup
column into the reference cell it works perfectly, I am guessing that somehow
there is a formatting issue with the data that comes from the database
(Access) and Excel I am just not sure what it is, I have pasted the data into
Notepad to see if there is anything added in the formatting but it is still
exactly the same as I typed. But if I then try and copy that back into the
reference cell I get the same error. Just wondering if anybody has got any
ideas how to fix this annoying problem.

Many Thanks

Windows Xp pro
Office 2003