Create Multiple Dependent Drop Down Lists in Excel (Demonstration with Example up to 3 Levels)

#DependentDropDownList #ExcelTricks #MSExcel

In this Tutorial it is discussed that how you can use multiple dependent dropdown lists in excel ? The practical example / demontration in the video is with 3 levels dependent dropdown list. The method discussed in this tutorial can be used to create multiple dependent drop down list up to multiple levels.

Below is the link to download excel sheet in order to practice discussed excel trick.

#exceltricks
#DependentDropDownList
#MSExcel
#ExcelTutorial
#MicrosoftOfficeTutorials

[MIA-hcnm]

Soooo much easier than all the other videos I watched. Thank you!

[denissymonds]

Great explanation & demonstration, worked perfectly. I did find that if the title is mad up of 2 or more words that you have to use the 'underscore' character instead of a space

[grace_chic]

very helpful, and this is the kind of tutorial that I'm looking for. Thank you very much!

[GollapudiShanmukh]

Thank you very much. Resolved my issue. I thought it was by using formulae. It is very simple.

[emiliomola]

Thank you for this! I got stuck using the offset and match functions using tables. The 'Create from Selection" works great.

[Adityaaani]

Thank you ! You explained very precisely which solved my issue..

[SarahJackCrane]

Thank you so much....this video was the answer I've been search for!

[dumarsrl]

but youre not linking anything, I mean how does it know that "Income" is linked to "service, products, byproducts". This just shows how to connect C7 to D column. I already named ranges, have the drop down lists, but my first column doesn't know that is supposed to be linked to the items on the second column. Thats my main problem

[kumaras]

Thank you very much :-) It's working and very helpful.

[kikyarsanfa]

Hi thanks for the video! I Have question how if i have different account name with same transaction details? for example there are 5 account name.
Office
Warehouse
Laboratory
Import
Export

office, warehouse, and laboratory have different transcaction details. import and export should have same option. Would appreciate if you can assist me. Thank you

[karaniparshotam]

Hey do you have a ready spreadsheet for accounts?

[lucionelucione]

Working. Question: after i complete a row, it is possible to modify the second variable and it doesnt appear an error. How is it possible to avoid someone can change second or third variable that is not dependent from first one.

[oneworldnovel]

Hi
I want to know that if I select 1 drop down from one column then the other column drop down should appear automatically, As the attributes are one one each in both the columns

[rubiindia]

Bro can you teach us how to make special uinque identify no as per multiple dependent selection like if let's asume income have id of 101 in the ref list and as per ref list byProduct with id 112 and 3rd quality plastic pipe id is 045 then in the uqiue id for this will show like 101-102-045 like this how we achive this in the new column like UID for that product

[jodu]

How it will works, if i have 25 main, 535 2nd and 5000+ in third cell ?

[missniral]

This formula using... Data evaluation error comming

[vickyeric]

Hi, After applying indirect formula in Data validation and clicked out, but nothing is showing in drop down list

[ABellaLuna]

Can this be done for more than 3 levels?

[ramadanibrahim]

thank you so much sir, if you please for example what if i want like
Account Category Account Name Transaction Details
Income Income Income

[abdulhamidalhaddadi]

The first column working fine, but the indirect It does not show any. MS Excel 2019.