Dropdown lists that are dependant on each other

[Angjo]

Hello all!
Really hope you can help. I need to make a drop down list that is dependant on another.
I have one sheet that looks like this:

What i would love to be able is to select a country and then have a second drop down that will only bring back the list, dependant on the first choice like follows:

So if you pick Afghanistan you get colours and if you pick Albania you get a list of material types etc.

I really hope this is possible and any help would be really appreciated!

Thanks!

 

[Alex Blakenburg]

In the first "t" is the table name. So if you haven't already convert your validation table range into a table (ctrl+T with a cell in the range selected)
I prefer to have my own table names starting with tbl but if you accept the default it is likely to be Table1.
Where Wyn has t[1] that would then be Table1[Country]

 

[Alex Blakenburg]

PS: I would probably stay with Wyn's approach. Mark version needs you to set up his Lamda function by copy pasting his code from the video description into the name manager and calling it DDL.