Create a searchable drop down list in Excel

This video will show you step by step how to create a searchable dropdown list in Excel.
This technique uses data validation and some formulas.
SEARCH, VLOOKUP, MAX, IF, IFERROR, COUNTIF, ROWS, OFFSET & ISNUMBER.
Create a searchable drop down list in excel.
+