simple formula to copy cells if another cell contains a Y

[brianaclark1967]

Hi Guys,

I've attached a simple sheet.

I want to copy the address from one column into another column, if a certain cell contains a "Y"

Looking forward to your solution

Regards

Brian

 

[Nunes]

Hi!

=IF($E$2="Y",C3,"")

in cell D3 and then just copy paste cell D3 downwards until the end of the list

Best
Nuno

 

[brianaclark1967]

Hi Nunes,

Thank you so much for your help.

Regards.

Brian