Mulitple CombBox lookup

[dagindi]

Attached is a sample spreadsheet.

Combobox1 Allows you to choose a room. In this example you can choose "Kitchen" or "Bathroom"

I Chose "Kitchen"

ComboBoxes 2 & 3 will then populate with the available products based on CombBox1.

I chose "Sink" for CB2 & "Oven" for CB3.

Under each product you can select the "Attributes". I select "Double" for both CB6 (Attribute for "Sink") and CB10 (Attribute for "Oven")

Here is where the issue pops up. Both the "Sink" & "Oven" have attribute "Double" however "Double" for "Sink" mean something different then "Double" for "Oven".

How do I rewrite the code (or lookup chart??) in CB7 & CB10 so they "look" at CB2 & CB6 and CB3 & CB10 and only returns attributes that match to the corresponding product/attribute(s).