Simple Dependent Drop-Down List in Excel - Excel Tips and Tricks

Learn how to create a dependent drop-down list in Excel.

To add a dependent drop-down list in Excel, first create your main drop-down list. Then, use data validation to link the options in the dependent list to the choices in the main list. For a dynamic drop-down list in Excel, utilize Excel Tables or named ranges to automatically adjust the list as you add or remove items. To create a drop-down list based on a cell value, set up a formula to generate the list based on the chosen cell's value. Lastly, for a drop-down list with multiple conditions, employ the "IF" or "INDEX/MATCH" functions to populate the list based on specified criteria.

At the end of the video you will be able to answer these question.
How do I add a dependent drop-down list in Excel?
How do I create a dynamic drop-down list in Excel?
How do I create a drop-down list in Excel based on a cell value?
How do I create a drop-down list in Excel with multiple conditions?

Here are the steps outlined in my vide.

Assign Name
1) Ctrl+A
2) Ctrl+G
3) Special
4) Constants
5) OK
6) Formula ~ Defined Names ~ Create from selection
7) Select "Top row" only
8) OK


Drop Down - Country
1) Select D24:D33
2) Data ~ Data Tools ~ Data Validation
3) Settings tab
4) List
5) Select Source and press F3
6) Country
7) Ok
8) Ok

Drop Down - Cities
1) Select E24:E33
2) Data ~ Data Tools ~ Data Validation
3) List
4) =INDIRECT($D24)
Press F4 twice
5) OK

How do I add a dependent drop-down list in Excel?,How do I create a dynamic drop-down list in Excel?,How do I create a drop-down list in Excel based on a cell value?,How do I create a drop-down list in Excel with multiple conditions?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks