Many SEARCHABLE Drop-Down Lists in Excel (No VBA)
I already shared a video on how you can create a SEARCHABLE drop-down list in Excel. The solution was for a SINGLE row. But now we'll take this to the next level and replicate the searchable drop-down list (which is a simple Excel data validation list) to MULTIPLE Excel rows without VBA and without combo-boxes. We'll be using the new excel Dynamic array functions which are a part of Excel for Office 365. With these functions we can create a data validation list that suggests search results based on the user input. The match is made based on any part of the text - the beginning, middle or end.
We'll use the the new FILTER function together with the SORT function. We'll combine these with legacy excel formulas like the SEARCH function (2:00) and the Transpose functions (8:30).
As a bonus we'll also cover the XLOOKUP formula (10:40)
★ Link to complete Excel Dynamic Arrays Class: https://courses.xelplus.com/p/excel-dynamic-array-formulas
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-searchable-drop-down-every-row
Check out the complete Excel for Office 365 playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
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
Видео Many SEARCHABLE Drop-Down Lists in Excel (No VBA) канала Leila Gharani
We'll use the the new FILTER function together with the SORT function. We'll combine these with legacy excel formulas like the SEARCH function (2:00) and the Transpose functions (8:30).
As a bonus we'll also cover the XLOOKUP formula (10:40)
★ Link to complete Excel Dynamic Arrays Class: https://courses.xelplus.com/p/excel-dynamic-array-formulas
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-searchable-drop-down-every-row
Check out the complete Excel for Office 365 playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
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
Видео Many SEARCHABLE Drop-Down Lists in Excel (No VBA) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Searchable Drop Down List in Excel (Very Easy with FILTER Function)Excel DGET Function Solves 2 of Your VLOOKUP ProblemsExcel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)Searchable drop down list for multiple cells4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1When Should you Use the Hash Sign (#) in Excel Formulas?Consolidate & Clean Multiple Excel Sheets in One Pivot Table🔎 How to Create Searchable Drop Down List in ExcelSURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)SUPER EASY Excel Data Entry Form (NO VBA)Return Multiple Match Results in Excel (2 methods)Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank CellsDon't Use Excel Filters! Use This Incredible Excel Formula Instead ...Excel Lookup to Return Multiple Values with FILTER FunctionExcel Drop Down List Tips and TricksHow to use Excel Index Match (the right way)Create a Searchable Drop Down List Just Like Google - Excel TrickBasic Excel Formulas and Functions You NEED to KNOW!