Apr 30 2019 04:26 PM
Hi @Match811
Try this in cell I3:
=IF(E3="Y",D3, "")
So if E3 is yes, the contents of D3 will be put into I3, if it is not then then I3 is blank.
Cheers
Damien
May 01 2019 03:38 PM
Thank you very much for your help.
The formula worked perfectly
Kind regards
Match811