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)


"MichaelK" wrote in message
om...
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