Quote:
Originally Posted by Matthew Williamson
I want to use the following IF ... THEN.
If any cell in column D contains x then put y in the same row in column G
and
If any cell in column D contains a then put b in the same row in column H
Can this be done?
|
It would involve a formula in G and one in H.
In G1 put
=IF(D1="X","Y","") and in H1 put
=IF(D1="A","B","")then copy both formulas down as needed.