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

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:

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

Amanda at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

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.

Scrawny

Related Q & A:

How do I make a window in Java?Best solution by Stack Overflow
How can I make a Spinner only by java?Best solution by stackoverflow.com
How do I make a python web program that is on a ubuntu server allow access to the server?Best solution by Yahoo! Answers
How can I make a download page?Best solution by Stack Overflow
How can I make a dynamic web page in PHP?Best solution by Yahoo! Answers

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.