Dropdown list based on previous dropdown selection

mmk2552

New member
Joined
Jun 26, 2013
Messages
1
Reaction score
0
Points
0
Hi
I am working on something and came across a situation which I am not able to get it done. I would prefer to do it by using excel formulas rather than VBA. I wish to get this accomplish using excel if possible. Can any expert guide me with this.

To make it simple this is what I want:
Say for example I have a first drop down which shows "List of States.". Based on what state you choose, I need the next column to give me a drop down of "Cities in that State"

So for example
If some body chooses Texas as State, The next column dropdown will show " Houston, Austin, San Antonio".
If you choose California as state, then the next column drop down will show " San Diego, Los Angelos, San Fransisco"

Can any one pls guide me. Again I wish to use excel formulas and NOT VBA.

Thanks
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
Here's one approach I've been working on that works without code, but also has some code in it to clear 'downstream' choices if upstream choices change. You can turn the code on or off, or even delete it entirely ...it's just there for informative purposes.

And you'll find more approaches at the following links:
http://www.contextures.com/xlDataVal02.html#Dynamic
http://www.myonlinetraininghub.com/excel-factor-19-dynamic-dependent-data-validation
http://www.get-digital-help.com/201...s-containing-unique-distinct-values-in-excel/
http://excelsemipro.com/2011/05/a-dynamic-dependent-drop-down-list-in-excel/
http://www.excel-user.com/2011/02/cascading-validation-lists.html
http://blogs.office.com/b/microsoft-excel/archive/2009/11/24/create-conditional-drop-down-lists.aspx


Note that my code still needs a bit of tweaking and error handling, which I should have done fairly soon if you in fact ultimately decide you want it.
 

Attachments

  • Dynamic Dependent dropdowns v4.xlsm
    23.7 KB · Views: 34
Top