Hi,

I am trying to use vlookup in Excel2003 to do some data manupulation
between data sets in two different sheets. My function looks like this:
=VLOOKUP(A62,Sheet2!A60:T11007,10,FALSE)
Cell A62 contains a number, for example: 3020200000
This function always returns #N/A.
If I enter the actual value instead of A62 then it works correctly.
I re-created the example in Excel's vlookup help, replaced the constant
value with a cell reference like I am using above and it was resolved
correctly.
What could be causing my application of vlookup not to work correctly?

Thanks for your help,
-Eric