How do I populate a cell with another cell's value based on condit

M

M Enfroy

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
 
M

M Enfroy

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
 
R

RagDyer

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!
==============================================
 
Top