software

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=quot;MTquot;,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

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

quot;Pamela Creightonquot; gt; wrote in message
...
gt;I have a colum that shows vlookups as text files
gt; another colum that is to do an index / hlookup on the vlook up cell, if I
gt; type in the same text in the vlookup colum the index / hlookup work if I
gt; leave the colum with a vlookup I receive a #N/A error if I copy and paste
gt; the vlookup as copy paste value it still does not work the only way the
gt; index / hlookup will work is if I physically type the field in
gt;
gt; colum K uses index and hlookup etc
gt; IF($G10=quot;MTquot;,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))
gt;
gt; Colum H
gt; has a vlookup field receive error #N/A in column K
gt; if I type in the same result as comes up with vlookup I receive the
gt; correct results in colum K
gt;
gt; it is as if the formula in colum K cannot use what Column H lookup reads
gt; on screen
gt; any suggesting greatly appreciated.
gt;
gt; Regards
gt; Pam
gt;
gt;
gt;