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).
Bookmarks