Nesting drop-down menus

A

Alonso

Hi everybody

i'm working with nested dropdown menus

in column A select a machine
in column B choose a product (depends on the machine)
in column C pick a style (based on the product and the machine)

using the INDIRECT function

so far, so good

what i want to do:
in column D, using another drop-down menu
to choose a color
but ONLY for certain machines

i thought using defined names
but lists named machine/product/style/colors
would be a lot of work
(4 machines * 5 products * 200 styles * 25 colors)


it's there a way to program a dropdown menu to appear only when specific
machines are selected??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter dropdown menu so 2nd drop menu is customized 1
Creating Drop-down menus with subset drop-down menus 4
Formatted cell column in drop down list 1
Date Range Drop Down Menu 1
Drop Down with dynamic named range offsheet source list 14
dependent drop down list 1
Dependent Validation 1
Maxing out nesting levels limitation of IF function 3

Top