Hi, Many thanks for your reply, I have tried your suggestion but to no avail,
the only difference was that the vlookup no longer worked if I copied and
pasted the text into the reference cell from the lookup column. I have
already set the formatting to Number, I have also tried a custom format
aswell but neither seem to make any difference.

Below is the Vlookup code I am using

=VLOOKUP(AA9,AB7:AG9999,1,FALSE)

And this is how I interpreted your solution

=VLOOKUP(AA9*1,AB7:AG9999,1,FALSE)

If I have got this wrong please let me know.

Many Thanks.

Windows Xp pro
Office 2003


"B. R.Ramachandran" wrote:

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