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

How to make repeating drop-down lists? 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Formatted cell column in drop down list 1
Filtered drop down list 2
Creating Drop-down menus with subset drop-down menus 4
lookup multiple criteria 7
Drop Down Menus 2
filter dropdown menu so 2nd drop menu is customized 1

Top