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-formulas

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

Видео Searchable Drop Down List in Excel (Very Easy with FILTER Function) канала Leila Gharani