This tutorial will show you how to create a dependent list on Excel.  This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3.  Cell B3 (City) will pull a city based off of the users selection.

1. Start with a list of categories. I chose to use State and cities for this demostration.   

   

2. In order to set up our validation list, we need to define names to each series. To begin, select cells D3-D5.  Right about colume A, type “State” and hit enter.     

   

3. Continue to define names for Ohio, Michigan, and Illinois.  Highlight cells E3-E5 and type “Ohio”    

   

4. Once the columns are defined, we can now create our dependent validation list. Click on Cell A3.
5. Click Data -> Data Validation ->Data Validation…
6. Once the Data Validation box is displayed, click the down arrow and select “List.”   

   

discuss this topic to forum