Dependent Lists with Conditional Statements

Okay, so I am working on a template and I am using Dependent Lists to ensure that accurate data is being brought into the appropriate cells, however I would like to simplify the users' job by using conditional statements to sort of "think" for the user.

In this example file I have uploaded, it shows how the user can choose from the drop-down lists in column A in order to apply the Specs that coincide with that type.

Essentially what I would like to happen is when the user selects a Relation Type in column A, the corresponding Specs appear in the cells marked in green so that they can then select the appropriate Spec Value from the drop-down list in the cell to the right of it.

In Row 2, you see that Variation Parent actually has multiple specs that should all be applied to that particular type. If this were done correctly, any time a user would select Variation Parent, the corresponding Specs in columns B, D, F, H, and J would all appear and the user would simply have to select the appropriate Spec Value for that item.

Does anyone know how I would accomplish this?

Any examples would be greatly appreciated.

Thanks in advance.

-Amy Kate

Here you go:

The formulas are in the green cells, I just inserted the formulas.

You can use the Evaluate Formula icon on the Formula Auditing toolbar to step through one of the formulas to see how it unfolds.