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.
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.