Enter this in F7:

=IF(A2="Joe",O1,IF(A2="Jim",P1,""))

--
HTH,

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


"M Enfroy" wrote in message
...
Sorry. Let me rephrase this properly

If the value of cell A2 = "Joe" then populate cell F7 with the value found
in cell O1 but if A2 ="Jim" then populate cell F7 with the value of P1


"M Enfroy" wrote:

How would I write the IF formula the do the following:

If the value of cell A2 = "Joe" then populate cell F7 with the value
found
in cell O1