Creating a drop down list from another drop down

[Jody]

I am new to the site so if I missed an answer to this question I apologize.

I have created a drop down list to show Regions example Central, East, West,
South, North. Based on the Region Selected I want to create a drop down that
will show the correct states for example if I select South I want the next
drop down to display only TX, LA, and MS, If I were to select West I would
want only CA, OR, WA. How can I do this? Thanks.

 

[Ron Coderre]

Best resource for learning about dependent lists: Debra Dalgleish's website:

http://www.contextures.com/xlDataVal02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[L. Howard Kittle]

Hi Jody,

One way is to name the state groups, Tx, La, Ms is named South, for example.
List all the names in a column, A1:A10
In B1 do a drop down of the named ranges (South, West ... etc.)
In another cell do a drop down, Allow List, and in Source enter:
=CHOOSE(MATCH(B1,A1:A8,0),West,North,South,East)

B1 is the first drop down which will display a region of choice.
A1:A10 is a list of the regions that you have named.
All the regions are entered in the formula, seperated by a comma. (no space
& Max of 29)

So, select a region in B1 and then click on the arrow in the 2nd drop down
as see the state choices for that region.

HTH
Regards,
Howard