multiple dynamic dependent drop downs

Hey all, I'm new here but looking for some help. I've spent a good deal of time trying to figure this out without luck. I'm trying to create 2 levels of dynamic dependent lists/dropdowns.

For example, I have the following data:

Please Login or Register  to view this content.

And I want to show the dropdowns as such:

• Colour Dropdown - shows unique Colours
• Type1 Dropdown - shows a list of values from Type1 based on the Colour chosen
• Type2 Dropdown - shows a list of values from Type2 based on the Colour chosen

Then use a lookup to get the price of type1 and type2 to be used in another cell for a calculation.

Also I would like to use it in rows so each row could have a Colour, Type1, Type2 and prices cells and a different choice of combinations for each row. Example:

Please Login or Register  to view this content.

I was able to figure out the formula for getting the unique Colours, so assume you already have a unique list of Colours. Also, I don't mind if the data needs to be rearranged to accommodate the formulas but I would prefer not setting static named ranges as I would like the data to be easily updatable by someone else (i.e. add new colours with new Types/Prices.). Note i"ve already got this all working with lots of static named ranges, but it would too hard to update or add new data.

Any help is appreciated.

Hi atomicrabbit and welcome to the forum,

Search on "Excel Cascading Dropdown" and see what you get.

Here is one of many sites
http://www.bluepecantraining.com/por...ists-in-excel/

unfortunately that link and most other methods of doing this require me to specify static named ranges and if I have 20 unique "colours", this is not very maintainable in the long run.

The closest thing I've found to be similar to what I want is the below link, but because I need 2 sets of data for each "colour" (type1, type1 cost, type2, typ2 cost), this solution is a start but still won't do what I would like to do:
http://excelsemipro.com/2012/04/a-dy...ble-reference/