Excel Dependent Drop Down List with Tabular Data without Named Ranges

Excel Dependent Drop Down List with Tabular Data without Named Ranges

 

 

Find out how to create a dependent drop down list in Excel based on a Tabular data set. Instead of having the contents of each drop-down beside each other as we had in the previous tutorial, we now have the contents of each drop-down right below one another. 

 

To distinguish which category belongs to which parent, the parent is listed right beside the category.  This provides us with a table that has two columns. One for the parent and the other for the content. 

We would like to come up with a dynamic formula so that when the user selects a category from the first drop-down (i.e. the parent list), Excel figures out which part of the tabular data-set to include in the 2nd drop-down. This means we need a dynamic formula that always shows the part of the table that has a match for the parent category.

Related Topics:

• Excel VBA: Referring to Ranges and Writing to Cells (Range, Cells, Offset, Names)
• Excel VBA tutorial for beginners: Object Properties and Methods 
• Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)
• Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)