How do I make a drop-down menu in Excel 2010 automatically select a range?

Question

I am using Excel 2010. I have one drop-down menu that functions perfectly.

What I want to do is have a second drop down menu populate based on what I select in the first one.

To elaborate:

Drop-down menu one has the following choices:
Dad
Mom
Amy
Sarah
Cheryl

I want drop down menu 2 to be different depending on what name I select.
If I chose "Dad", the choices for the second menu should be "Honda Goldwing", "Chevy Oversized Pickup", and "Jeep Cheroke".

But, if I select "Amy", the choices for the second menu should be "Lexus ES300, Jeep Wrangler", etc.

I could just list everything in the second drop down menu, but that isn't any kind of fun! Not that I'm stubborn. Alas, I have not been able to figure this out. I've tried messing around with "IF" statements, but those apparently only work on numeric values? I'm not sure what other tools to use to make this project possible.

Assistance would be much appreciated.

Answer 1

Dependent drop down lists take a bit of time.. here's a good tutorial:

Answer 2

Drop Down Menus In Excel 2010

Answer 3

Dependant drop down lists rely on ranges that are named. Using your example, the first drop down list is simply a list of



Dad

Mom

Amy

Sarah

Cheryl



Each item in this drop down list will need to have a list named exactly as the items in the list so you will need a lists named "Dad", "Mom", "Amy", "Sarah", and "Cheryl"



These lists will have the selections that pertain to whatever is chosen from the first drop down list.



To create the named lists start off with the titles of each list so that you can easily keep track of what list you are working on. When you have a list completed, select all the cells of the list except for the title cell and in the upper left of the Excel window to the left of the Formula Bar is a field with a cell reference in it. Click in this field and Enter the title of your list and hit enter. Repeat this for each of the lists that you are creating.



The Excel help file has some good tutorials but the above is the basics of how to set it up.

Answer 4

seems such as you're filling lot of information employing your keyboard and you do no longer choose to toggle between keyboard and mouse. in simple terms press Alt+Down Arrow for the record to pop-up and you may use your arrow keys and tab to make a call from the Dropdown. wish this permits.