How to Make a Multi dependent drop-down list in excel | 100 percent working on Digi mastery

Описание: Hi Friends, In this video you will learn about how to Make Multi Dependent drop-down list in excel, that is very easy way to create dependent drop-down list by using Xlookup function. no need complex formulas for this.
#excel
#xlookup
#howtomake

00:00 Introduction
00:52 make simple drop-down list
01:48 make dependent drop-down list
02:04 using Xlookup function
03:42 make dependent drop-down list with xlookup output
05:02 use unique function
06:12 use sort function
07:50 ending and wrap up

For more excel tutorial click links given as under:
Introduction to excel lesson1    • introduction to Microsoft Excel II Beginne...  
data enter and formatting    • MS Excel data entry and simple calculation...  
autofill and customize autofill    • MS Excel AutoFill ll Customize Autofill  
cell Referencing    • Relative, Absolute and Mixed cell referenc...  
data entry editing formatting    • Data entering, Editing, Formatting and Del...  
formula and function    • Formula and Function in EXCEL ll Microsoft...  
Flash Fill    • Flash fill in detail ll Microsoft Excel Fl...  
Justify Fill    • justify Fill in Excel ll Microsoft Excel S...  
cell modes in Excel    • Excel cell Modes ll Microsoft Excel Series...  
Easy Data entry form    • Excel Easy Data Entry Form without VBA  ll...  
top 4 sum formula    • Top 4 Sum Formula in Excel ll Microsoft Ex...  
checkbox use in excel    • Checkbox use properly in Excel ll Microsof...  
all count formulas    • Count formulas in excel ll Microsoft Excel...  
searchable drop down list    • Searchable dropdown list in excel without ...  
5 important shortcut excel    • Important shortcuts excel ll Microsoft Exc...  
balance sheet in excel    • Видео  
remove data duplicates    • Remove duplicate In Excel | Microsoft Exce...  
number group in excel    • Number Group in Excel | MS Excel Series | ...  
custom format in excel    • Custom Format in excel | Microsoft Excel S...  
basic excel filter part-1    • Basic Excel Filter | Microsoft Excel Serie...  
basic excel filter part-2    • Basic Excel Filter part 2 | Microsoft Exce...  
excel data transfer automatically    • Transfer data Automatically in excel sheet...  
date picker add in excel    • date picker add in excel | easy way to add in  
income and expense in excel    • Best way to create income and expense Dash...  
10 $ earn with data cleaning    • Earning in 2023 with Excel as Freelancer |...  
add header and footer in excel    • Add header and footer in excel worksheet |...  
multiple matches of one item    • One item matches multiple Results in excel...  
sort function detail in excel    • Sort Function in Detail in excel | sort fu...  
unique function detail excel    • Unique Function in detail | Microsoft Exce...  
how to earn 15 to 150 dollar    • How to Earn $15 to $150 in just few minute...  
xlookup function in detail    • XLOOKUP Function detail in excel | Microso...  
transfer data with pivot table    • Transfer data from Master sheet to Multipl...  
Filter function in detail    • Filter Function detail in Excel | Microsof...  

subscribe to my YouTube channel that is appreciation from your side
Thanks for watching

finger pointed picture link
https://www.freepik.com/free-photo/cl...