I need to copy a cell from sheet 1 to sheet 2 if a refrence happ

Closed
ekaelraie Posts 1 Registration date Wednesday January 20, 2016 Status Member Last seen January 20, 2016 - Jan 20, 2016 at 04:08 AM
Hello,
I want to know how to make a formula for below example
if G2 at sheet 1 equal yes
copy F2 at sheet 1 to A2 at sheet 2
and
if G2 at sheet 1 equal NO
copy F2 at sheet 1 to A2 at sheet 3


Related: