VLOOKUP #NA unless retyped

[Bob L]

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

 

[Ken]

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

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.