Example

A1:17
B1:=A1*2
C1:=IF(B130,"30","<30")

is that what you mean?

--

HTH

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


"Judy" wrote in message
...
Can anyone provide instruction on how to make a secondary function (in a
separate column) look up the value (result) of the first function without
having to paste the values. Thanks in advance!