SEARCHABLE Drop-Down Lists in Excel (without VBA)
Access our COMPLETE Excel Course HERE
In this tutorial I demonstrate how we can use the NEW dynamic functions available in Office 365 to create searchable drop-down lists.
First I look at creating the require formula to allow a SINGLE drop down then we identify the challenges and create a SIMPLE solution to allow MULTIPLE drop-downs.
Download tutorial workbook HERE