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.

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.

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.

Is that what you type as the lookup value or is that what you type into the
column you are trying to find the value in?

I assume it is the latter, then most likely you have hidden characters in
the import, you can try

=VLOOKUP(C6,TRIM(vlookupjulychg),2,0)

entered with ctrl + shift & enter, if that doesn't work I would suggest a
macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

will remove all extra characters, same web site has instructions on how to
install and run macros, you could just attach the macro to a button, select
the import and run the macro after each import



--


Regards,

Peo Sjoblom

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







"Ravenbear" wrote in message
...
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.