Dependent Dropdown Lists

[benntw]

I have a table that is a parts list table. The table is called MatList. Column A is Material Type, Column B is Description, Column C is Size, and Column D is part #. Column A has multiple lines with the same name as well as what is in column B & column C. On sheet Material Needs is a table called MatNeeds. THis table is to be used to show what they need on a project. Column B is the material type, column C is the description, and column D is the size. Column E auto populates what the part number will be. What I am looking for is column B on Material needs to have a drop down to only show unique values from the parts list sheet. Then once you select the material type then I need a dependent dropdown list to get the unique value for description off of the parts list and finally once you slect that I need a dropdown list of unique values to give me the sizes. I know there is a way if I make a look up sheet with horizontal header names, but I want to be able to use the parts list that is already there. Is there a way to do this to have multiple dependent dropdown lists.

 

[Alex Blakenburg]

See if this video by Mynda Treacy helps, it is only around 7 min long.

 

[benntw]

Thank you. I followed her video which works perfect for a dropdown list and 1 dependent list. Now I just have to figure out how to make the 3rd dropdown dependent on the 1st and 2nd dropdowns.

 

[Akuini]

Thank you. I followed her video which works perfect for a dropdown list and 1 dependent list. Now I just have to figure out how to make the 3rd dropdown dependent on the 1st and 2nd dropdowns.

Please check an example of 3 dependent data validation in post #30 in this thread:
3-or-more-dependent-data-validation