Drop-down lists are very common in the web world and you can also create it easily in Excel. In this video, I will show you how to create a dependent drop-down list in Excel (also known as a conditional drop-down list).
What is a Dependent Drop-down List in Excel?
While a drop down list allows you select an item from a list, a dependent drop-down list allows you to change the items in a drop down based on what you have already selected. For example, if you have a drop down list that shows products in the company, then selecting any one of the products would enable the dependent drop down to show the version of the selected product only.
This means that when you select an item from a drop-down list, another list which is dependent on the first one automatically gets updated.
Here is another simple example. You have two drop down lists with the first one showing countries and the second one showing states. You select the US, and all the states in the US appear in the adjacent drop down. And when you select India, all the states in India appear.
A step-by-step tutorial and download file:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Dependent Drop-down List in Excel | Conditional Drop Down List in Excel | Dependent Drop Down List #Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
"I WILL JUST PRESS F4 THRICE"?????????????????? THANKS FOR NOT EXPLAINING. I WILL PRESS DISLIKE THRICE.
An excellent video and very well explained. I have just used this method on two datasets. Thanks. Rog.
Thanx!
👏 thanks 🙏
can drop down lists be done via yes and no answers? cant see to get it using these answer sets
Hello, it is very easy for you to give information about Excel … but if you give understanding in Hindi language, it can give more understanding to everyone … thank you
You did a superb job on this, very easy to follow and helpful. Exactly what I was trying to accomplish. I didn't even know that it was possible so I was glad I found this vid. Thanks very much!
while using the "Indirect" formula It says … The Source currently evaluates to an error. Do you wish to continue?….what to do
Thank you very much. Easy to understand directions. I saved a lot of time by using this method.
do you need to convert the range into a table?
This is exactly what I was looking for, but unfortunately I'm getting an error using the =indirect(ref) formula.
The error is 'The Source currently evaluates to an error. Do you want to continue? Does anyone know how to solve this?
This was such a great video. Straight to the point and so well explained, bless you!
This was just what i needed. Thanks for this and for getting straight to the meat 🙂
You are the best!
THIS IS GARBAGE.
Do you have show about extract data with two criteria , i find so many but not see.
Great video. Easy, concise. For people getting an error, make sure that your selections in the first drop down match exactly the Range Names that were created. If you have selections in your first drop down box that have spaces in them (United States), the name that got created during this process will be United_States with an underscore. You'll get an error on this Data Validation until you update your headings to also have the underscores or update your range names. Should work perfectly after that. Great video! Thanks.
you are my hero! for real!!! thanks so much!!!!
I cannot key in "=indirect(Cell)" Into the source box.
i will always get an error
Excellent! Thank you sir
Great tutorial!
dear Sir,
your tutorials are very useful for me in my office.
I want to know, how to do the conditional formatting with date by interning the date in a cell the whole row will be in same format (same fill color)
thanks