Forum Discussion

Lycias's avatar
Lycias
Brass Contributor
May 23, 2023

How can I create multiple dependent drop down lists

I want to create multiple dependent drop-down lists from the file below. When I select a country in column B I want only entries from column D for that country to appear in the next drop-down list, a...
excel
Cangkir's avatar
Cangkir
Brass Contributor
May 28, 2023

Lycias 

Here's an example of 3 level dependent data-validation using the new function in Excel 365. The functions used are: SORT, UNIQUE, FILTER, XLOOKUP & TEXTSPLIT

https://www.mrexcel.com/board/threads/3-or-more-dependent-data-validation-with-vba-easy-to-set-up.1185808/post-6010313

Resources