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

[dagindi]

Bump Bump....

[dagindi]

I found a solution (not a good one) but a solution.

If I incorporate textboxes then the following code works:

Please Login or Register  to view this content.

This is going to be pretty tedious to maintain as lists grow.

I'm not hung up on using text-boxes but if there is a way to "minimize" the code that has to be typed, i would greatly appreciate knowing what it is!

Thanks!

[dagindi]

So while the last code posted works, it still doesn't solve the issue of having a 3rd drop-down which provides choices based on the first two.

Can it be the this is the end all be all stumper?

[dagindi]

Bumpity Bump Bump

[FDibbins]

i tried to check your file, but combo1 and 2 dont show any values. however, i did notice that the ranges for those 2 include both categories. maybe you could change that so you have 2 different ranges, so that sinks have their own lookup and ovens have a different 1?

[dagindi]

I just checked the sample sheet provided and they have the values.