VLOOKUP problem
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. |
VLOOKUP problem
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. |
VLOOKUP problem
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. |
VLOOKUP problem
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. |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com