Value of adjacent cell in new cell [Closed]

Report
Posts
1
Registration date
Tuesday November 11, 2014
Status
Member
Last seen
November 11, 2014
-
I have 4 columns of data and I want to put the value of of the cell containing the date which is in column b based on if the word start1 is found in column d. I want the value of the date cell
To be placed in a new cell located on a different sheet.

Example
B2 contains the date 10/22/14
D2 contains "start 1"
I want a formula in cell c2 on a different sheet to put the value of b2 when if finds the word "start 1" in the adjacent cell in column D.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!