I have a colum that shows vlookups as text files
another colum that is to do an index / hlookup on the vlook up cell, if I
type in the same text in the vlookup colum the index / hlookup work if I
leave the colum with a vlookup I receive a #N/A error if I copy and paste
the vlookup as copy paste value it still does not work the only way the
index / hlookup will work is if I physically type the field in

colum K uses index and hlookup etc
IF($G10="MT",0,(($I10*(1+(INDEX(Packfactor!$A$2:$G $34,LOOKUP($J10,Packfactor!$A:$A,ROW(Packfactor!$A :$A))-1,LOOKUP($H10,Packfactor!$2:$2,COLUMN(Packfactor!$ 2:$2)))/100)+(HLOOKUP($H10,Packfactor!$2:$5,4,FALSE)*(HLOO KUP($H10,Packfactor!$2:$3,2,FALSE)-$I10))))/HLOOKUP($H10,Packfactor!$2:$3,2,FALSE))*HLOOKUP($H 10,Packfactor!$2:$4,3,FALSE))

Colum H
has a vlookup field receive error #N/A in column K
if I type in the same result as comes up with vlookup I receive the correct
results in colum K

it is as if the formula in colum K cannot use what Column H lookup reads on
screen
any suggesting greatly appreciated.

Regards
Pam