Help the ignorant.....

M

MichaelK

Let me try to explain what I'm trying to do...

Lets says cell C3 will be "value A" if A1=84, "value B" if A1=72
"value c" if A1=60 or "value d" if A1=48. Values A,B,C or D would be
pulled from a different worksheet cell where a different formula has
already been done. This seems like it should be simple, but I can't
figure out how to do it....

Thanks in advance....

Michael
 
B

Bob Phillips

In C3

=IF(A1=84,X1,IF(A1=72,X2,IF(A1=60,X3,ID(A1=48,X4,""))))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Don Guillett

If you want to use IF, start at the higher number and work down
=if(a1=84,"a",if(a1=72,"b",etc
but lookup would be better. Look in HELP index for vlookup or lookup
 
Top