Display multiple outputs based on combination of multiple inputs

Thanks to anyone who takes the time to look into my problem.

What I need is kind of hard to explain, even more difficult to research, but I think I have it outlined fairly well in the attachment.

Basicly, based on the combination of two inputs I need to determine if testing is needed. Then, if so, based on a certain date, I need a range of dates.

Something to the effect of, and I know this is nowhere near right;
=IF (B2 = "PPC" and C2= "New Item" then D2 = A2-21, E2= A2-11, F2=A2-1, G2 = NA (for example 1 on the attachment)

I extend much gratitude to anyone willing to help.

How about if statement

help (4).xlsx

Thanks for looking at it. Your help is close to what I need, but I think it neglects the "shipping method." You can see the effect of this under "test 3" option 4. The requirments are different than my example. I REALLY DO appreciate the attempt though.

It needs to be something to reflect;
=IF (B2 = "PPC" and C2= "New Item") then D2 = A2-21, E2= A2-11, F2=A2-1, G2 = NA (for example 1 on the attachment)
=IF (B3 = "PPC" and C3= "Re-Oreder") then D3 = NA, E3= NA, F3=NA, G3 = A3 (for example 2 on the attachment)
=IF (B4 = "FCA" and C4= "New Item") then D4 = A4-21, E4= A4-11, F4=A4-1, G4 = NA (for example 3 on the attachment)
=IF (B5 = "FCA" and C2= "Re-Order") then D5 = NA, E5= NA, F5=A5-1, G5 = NA (for example 4 on the attachment)

try the attached

Ah yes neglected the shipping methods. Fdibbins provided it with his sample file.
Thanks.

yes, test 3 was the tricky 1 lol

I have tested it in various scenario's..... so far, so good. Thanks Guys, good people like yourselves make this forum a life saver. I hope that I will be able to contribute quallity assistance at some point.