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.