Just have J4 reference M4.

In J4 enter:

=M4


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Janice" wrote in message
...
Say my If function is located in M4 and the query is to check the value in
D4, I would like the result to be put into J4 (or wherever) - is this
possible?