show a range off a drop down menu Solved/Closed

Question

Hello,  
What I'm trying to do is make a drop down menu that when you pick an option from it, the column next to it changes to a list corresponding to what you picked.  The amount of things on the list varies from one thing to another. 

Example: 
You pick Hamburgers so it lists:  
Hamburger 
Cheeseburger 
Turkey burger 

Or you pick Pizza so it lists:       
Cheese 
Pepperoni 
Meat lovers 
Vegetarian 


Configuration: Windows 7 / Internet Explorer 8.0

TrowaD · Answer

Hi Brazell,

To do this you need to create 3 lists:

List 1:
Hamburgers
Pizza

List 2:
Hamburger 
Cheeseburger 
Turkey burger 

List 3:
Cheese 
Pepperoni 
Meat lovers 
Vegetarian

Now select list 2. Now look above the letter A of column A. It will show you the top cell of your selected list (If the range of your list is A3:A5, it will show A3.).
Change it to Hamburgers.

Do the same for list 3 but now name it Pizza.

Now on to the actual validation.
Select a cell, let's say A1. Goto top menu > data > validation.
Choose list and select the range of list 1.

Now goto the cell where you want to put your second drop down list.
Goto top menu > data > validation.
Choose list and type in this formula: =INDIRECT(A1)

If A1 is empty a question will pop up, answer with yes.

And done you are.

Best regards,
Trowa

Show a range off a drop down menu

1 response

Similar discussions

Subscribe To Our Newsletter!