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