Excel Dependent Drop Down List with Tabular Data without Named Ranges

Nov 9, 2017 Excel Dashboards & Reports
Download the Workbook: http://www.xelplus.com/excel-dependent-drop-down-list-tabular-data/

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.

Link to extracting unique items for drop-down: https://youtu.be/7fYlWeMQ6L8
Link to OFFSET video: https://youtu.be/RPTQjbk2qy4
Link to the other Dependent Drop-down List video: https://youtu.be/w7cHgsFirLk

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel