Can I create an "If and If, then" for two drop down fields with PARENT values to get the CHILD Values? Quilt?

[Wyntersommers]

I'm trying to figure out how to select two values from a drop down list and then to to a table on another tab to pull out a sub value.

I have SIZE as a drop down (pulling from a named range)
I have COLOR as a drop down (pulling from a named range of parent colors, which have child colors).

When the COLOR is selected, one child color populates a different cell. Now what I'm trying to do is populate a cell next to the child color with a specific amount based on what was selected in the SIZE above.

SIZE (drop down: Small, Med, Large) {Cell A1}
COLOR (drop down: Sunset, Beach) {Cell B1}

If "Sunset" selected in {cell B1} color,
{Cell D2} Child Color 1:Red, (Need to populate yard amount in Cell D3 for Red fabric based on size selected in A1 )
{Cell E2} Child Color 2: Orange, (Need to populate yard amount in Cell E3 for Orange Fabric based on size selected in A1)
{Cell F2} Child Color 3: Yellow (Need to populate yard amount in Cell F3 for Yellow Fabric based on size selected in A1 )
==================================
Does anybody know how to do this?

Can I create a simple "If Size is X, AND Color is Y, then next to Child Color 1 is A, Child Color 2 is B, Child color 3 is C, etc" Type formula?
===================================
All the yard amounts needed are on the "Amount" tab and there is the list of Child colors for "Beach" in one table and Child colors for "Sunset" in another table on the same tab.

 

[Wyntersommers]

May I add one other complication is that the Parent Colors (in this example Sunset and Beach) both share sub colors in different amounts.

So
Beach Child 3= yellow for 3 Yards for size Medium
Sunset Child 3= yellow for 2 yards for size Medium

This is all in a chart, but I'm trying to get the correct "yellow" yards to show up when I click a certain size and Parent Color (and I have a gazzillion combinations in this spreadsheet, so any help you can give me would be ULTRA HELPFUL)