P
Pamela Creighton
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)*(HLOOKUP($H10,Packfactor!$2:$3,2,FALSE)-$I10))))/HLOOKUP($H10,Packfactor!$2:$3,2,FALSE))*HLOOKUP($H10,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
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)*(HLOOKUP($H10,Packfactor!$2:$3,2,FALSE)-$I10))))/HLOOKUP($H10,Packfactor!$2:$3,2,FALSE))*HLOOKUP($H10,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