Searchable Drop Down List in Excel (Very Easy with FILTER Function)
★ Link to complete Excel Dynamic Arrays Course: https://courses.xelplus.com/p/....excel-dynamic-array-
This technique uses data validation and (simple) Excel formulas to create a searchable data validation drop-down list. We use the Excel SEARCH function, ISNUMBER as well as the brand NEW Dynamic Array FILTER function. To make sure our searchable data validation drop-down list is sorted, we use the new dynamic array SORT function.
We also use the FILTER functions instead of VLOOKUP or INDEX & MATCH to find the value that matches our selection.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps:
00:00 Searchable Data Validation in Excel without VBA
01:11 Searchable Drop-Down List with Excel Dynamic Arrays
02:53 Excel SEARCH function
04:56 Excel ISNUMBER function
05:18 Excel FILTER function
06:42 Excel UNIQUE function
07:05 Excel SORT function
07:16 Create Data validation list with Excel Spill Array
08:26 Excel FILTER function for Lookup
09:28 Using Official Excel Tables
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/searchable-drop-down-list/
LINKS to related videos:
Dynamic arrays announcement: https://youtu.be/2USJsIyIzvo
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel