Thread: How do I populate a cell with another cell's value based on condit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Enfroy
 
Posts: n/a
Default How do I populate a cell with another cell's value based on condit
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
Reply With QuoteReply With Quote