Download the featured file from this page https://www.bluepecantraining.com/create-a-searchable-drop-down-in-excel/

This video demonstrates how to create a searchable drop down list in Excel. Excel features and functions used include:

Data Validation
Name Manager
SEARCH
ISNUMBER
IF
MAX
ROW
INDEX
MATCH
OFFSET
------------------------