Published on 03 Nov 2012 | over 4 years ago
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.