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.