When you want to automate an Excel dashboard, then you can use Excel Tools Data Validation to create a dependent dropdown list, and today we will learn how to create a searchable drop-down in Excel. If you are an Office 365 user then it is very easy to make it. In this video we will learn how to create searchable drop-down list in office 365 and older versions of excel.
To know more watch this video till the end
Time Stamps:
Searchable Data Validation in Excel without VBA
Searchable Drop-Down List with Excel Dynamic Arrays
Excel SEARCH function
Excel ISNUMBER function
Excel FILTER function
Excel UNIQUE function
Excel FILTER function for Lookup
Subscribe YouTube & Follow on Dailymotion and Like Facebook Page👇
/ exceluniverse
https://www.dailymotion.com/exceluniv...
www.facebook.com/exceluniverse.pkp
Also Watch
Dependent Drop-down List👇
• How To Create Drop Down List in Excel
Excel IS Function👇
• IS Function-ISBLANK, ISERROR, ISERR, ISEVE...
Index Match Function👇
• Index Match Function in Excel
Offset Function👇
• Offset Function in Excel Part-2
• Offset Function in Excel Part-1
Excel 365 Filter Function👇
• Filter Function in Excel - Best Way of Lookup
Download Practice file here👇
https://mega.nz/file/QjInyKRZ#ATGls8v...