Buy Dideo Subscription
Join over 20,000+ professionals in our courses: https://www.xelplus.com/courses/ 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
