VLOOKUP #NA unless retyped

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 9000 row, 8 colum worksheet that I have a range named Tprice
I am using the following function
=VLOOKUP(A15,Tprice,2,FALSE)
I get the dreaded #NA unless I go back and retype the cell on the main Tprice sheet. I had this problem in a prior version of Excel and was given a macro that retypes the column, I have tried running that macro and it does not make a diference in excell 2003, unless I am doing something wrong.
Does anyone have any suggestions, I do not want to retype all 9000 cells manually.
Thank you very much
 
If you want to send me your workbook, I'll take a look at
it.
-----Original Message-----
I have a 9000 row, 8 colum worksheet that I have a range named Tprice
I am using the following function
=VLOOKUP(A15,Tprice,2,FALSE)
I get the dreaded #NA unless I go back and retype the
Click to expand...
cell on the main Tprice sheet. I had this problem in a
prior version of Excel and was given a macro that retypes
the column, I have tried running that macro and it does
not make a diference in excell 2003, unless I am doing
something wrong.
 
Back
Top