Need help writing / combining formulas

Hi!

So I have to combine the below formulas / logic and I am not managing it.... I keep getting value errors or name errors... I would really appreciate your help!

I have attached my data set.

I need to combine:

=IF(A1="New Color",C1) (logic: if A has the value "New Color", populate column G with the value in column C)
=IF(A1="New Product",D1) (logic: if A has the value "New Product", populate column G with the value in column D)
=IF(B1="",IF(D1="",C1,D1),"Exception") (this formula is the formula that was in the file and that someone else input and frankly, I don't understand it... can someone explain? basically the part I know about it is that if there a value in column B it needs to say: "Exception" in column G... but I don't understand what the formula is doing if there is no value in column B. Either way, I need part of my combined formula to include a bit of it that will incorporate this logic)

Basically to sum it up, the combined formula just needs to have the part in red but it also needs to consider column A values for New Color and New Product. If New Color it needs to look at values in column C and if New Product it needs to look at values in column D.

Hope it makes sense!

Thank you..

I actually have one more thing!

The formula works great but I need to add a condition to it and I can't manage to make it work...

IF B column has a value, G needs to have the label "Exception" in it. If B doesn't have a value, then apply this entire formula: =IF(A3="New Color",C3,IF(A3="New Product",D3,"Exception"))

Is that possible??

G3: =IF(B3<>"","Exception",IF(A3="New Color",C3,IF(A3="New Product",D3,"Exception")))

If that takes care of your post #5 question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

and read Forum Rules point 4

You are welcome
and Yes, You should

Did you check file from post#4 of Need help understanding complicated IF formula in order to update thread?