Index / Hlookup

  • Thread starter Pamela Creighton
  • Start date
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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top