software

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.

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

www.contextures.com/xlDataVal02.html

Does that help?

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

XL2002, WinXP-Proquot;Jodyquot; wrote:

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

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
amp; 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

quot;Jodyquot; gt; wrote in message
...
gt;I am new to the site so if I missed an answer to this question I apologize.
gt;
gt; I have created a drop down list to show Regions example Central, East,
gt; West,
gt; South, North. Based on the Region Selected I want to create a drop down
gt; that
gt; will show the correct states for example if I select South I want the next
gt; drop down to display only TX, LA, and MS, If I were to select West I
gt; would
gt; want only CA, OR, WA. How can I do this? Thanks.