Need a formula to copy data from one cell if criteria met in another cell.

Delilah

Not sure if can be done. For the columns shown below, I need to copy text from the STATUS column into Status Phase only if column Dev Pipeline has a 1 or 2 in it.

Thanks for any suggestions.

John Shane

@Delilah

Based on your criteria, the formula below should copy the information for you. It will return a blank Status Phase for any input in the Pipeline Dev column other than 1 or 2, and can be turned into a column formula.

=IF([Pipeline Dev]@row = 1, Status@row, IF([Pipeline Dev]@row = 2, Status@row, ""))

Cheers,

John

John Shane

@Delilah

Based on your criteria, the formula below should copy the information for you. It will return a blank Status Phase for any input in the Pipeline Dev column other than 1 or 2, and can be turned into a column formula.

=IF([Pipeline Dev]@row = 1, Status@row, IF([Pipeline Dev]@row = 2, Status@row, ""))

Cheers,

John

Paul Newcome

Give this a go:

=IF(OR([Pipeline Dev]@row = 1, [Pipeline Dev]@row = 2), Status@row)

Delilah

Thank you! That did it. I was so close on my formula, but just one added or missing piece and it doesn't work.