Index / Hlookup

[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

 

[Peo Sjoblom]

Do this comparison, assume the formula returns it's value in

A2

in another cell (let's say C2) type in the result of the formula

then in a third cell test

=A2=C2

it will return FALSE since they don't match

then try

=TRIM(A2)=C2

if you get TRUE you have extra spaces in the formula

or if they are supposed to be numbers

=--(A2)=C2



--
Regards,

Peo Sjoblom

Portland, Oregon