Searchable Dropdown and Dependent Dropdown in Excel 

In this video we will show you how to make a Searchable Dropdown and Dependent Dropdown in Excel. In the process you will learn how to look for a value from a table with more than one criteria. The following functions are taught in this video: INDEX, MATCH, FILTER, SORT, UNIQUE, SEARCH, ISNUMBER, IFERROR. Also, you will see a practical application of the data validation feature in this video.
Link to download practice file: shorturl.at/JGyHB
Excel dropdown
excel drop down list
excel drop down formula
excel drop down list not working
How to do a drop down in an Excel?
How to create drop down list in Excel with multiple selections
excel drop-down list formula
Excel drop-down list edit
How to create drop down list but show different values in Excel
excel drop-down list without clicking
how to link a cell value with a an excel drop-down list
Excel drop-down list from another sheet
excel dropdown list
excel dropdown select