Even easier than easiest - Multi Level Dependent Drop Down Lists

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-...
File Reference for this video: 0238 Even easier dependent drop down lists.zip

★ About this video ★
We have looked at easy methods for multi-level dependent dropdown lists before. But this video includes an even easier method.

So... if you're ready, let's get started.

0:00 Introduction
0:16 Scenario
1:10 Creating dropdown lists with the DDL function
3:04 What is the DDL function?
4:23 How to get the DDL function?
5:47 Grouping data with the DDLSorter function
7:12 Wrap-up

Wyn Hopkins Video:    • Easiest Multi Level Drop Down List ( ...  
My Previous Video:    • Easiest Multi-Level Drop-Down Lists i...  


💻 DDL Function:
=LAMBDA(range,[lookup1],[lookup2],[lookup3],[lookup4],[lookup5],[lookup6],[lookup7],[lookup8],[lookup9],[lookup10],
LET(
_s, "%^&&@",
lookupValue, lookup1 & _s & lookup2 & _s & lookup3 & _s & lookup4 & _s & lookup5 & _s & lookup6 & _s & lookup7 & _s & lookup8 & _s & lookup9 & _s & lookup10,
levelIndex, IFERROR(ROWS(TEXTSPLIT(lookupValue, , _s, TRUE())), 0) + 1,
lookupArray, BYROW(EXPAND(CHOOSECOLS(range, SEQUENCE(1, levelIndex - 1)), , 10, ""), LAMBDA(row, TEXTJOIN(_s, FALSE, row))),
returnRange, INDEX(range, 0, levelIndex),
result, IF(ISOMITTED(lookup1) * levelIndex = 1, returnRange, XLOOKUP(lookupValue, lookupArray, returnRange):XLOOKUP(lookupValue, lookupArray, returnRange, , , -1)),
result))


💻 DDLSorter Function:
=LAMBDA(Range,[SortOrder],SORT(Range, SEQUENCE(, COLUMNS(Range)), SortOrder))

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel