In this article, we have created a Searchable and Dependent Drop-down list in Microsoft Excel. We have used Dynamic Array function of office 365 to create the drop-down list.
We have used UNIQUE, FILTER and SORT function.
Also see below tutorials:
- 6 Powerful Dynamic Array Function in Excel
- Searchable Drop down list for Multiple Cells
- Universal Searchable Drop-down List in Excel
![Searchable and Dependent Drop-down list](https://www.pk-anexcelexpert.com/wp-content/uploads/2022/09/Searchable-and-Dependent-Drop-down-list.jpg)