I simply retype what is in the field and it works. For example:

The field already contained MS10-7112-00, I typed that again and the
formula worked.



"Peo Sjoblom" wrote:

Example of what you type when it works?


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Ravenbear" wrote in message
...
I have a spreadsheet that uses this simple VLOOKUP formula:

=VLOOKUP(C6,vlookupjulychg,2,0)

The vlookupjulychg range refers to a table that originates from a report
downloaded from my mainframe. This formula returns a #N/A error. If I
retype the number that is being looked up, the formula works correctly.
The
lookup column is an alpha-numeric column. That makes me think it's a
formatting issue, but I can't seem to figure it out.

Any help would be greatly appreciated. This is a monthly process, so
manual
entry is not my first choice.