Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list from another drop down
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list from another drop down
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 "Jody" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list from another drop down
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 "Jody" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Drop list affected by previous choice | Excel Worksheet Functions | |||
Adding value to drop down list | Excel Discussion (Misc queries) | |||
Problems with external references when creating a drop down list | Excel Discussion (Misc queries) |