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