Excel - Create Dynamic and Dependant Drop Down Lists

A lesson on how to create dynamic and dependant drop down lists is Microsoft Excel. Join me on this data validation tutorial. I also go over the INDIRECT function as well as how to create a table.
00:01 Intro
00:19 Indirect Function
01:39 Create Table
02:24 Dynamic Drop Down List
03:35 Dependant Drop Down List
06:02 Thanks For Watching
Like and Subscribe!
/ @jasonlucasexcel
#dropdownlist #exceltutorial #datavalidation

[@asaf996]

Great tips! Thanks
Could you make a vid explaining how can I choose a state from a dropdown and it will automatically give me the matching city?

[@JasonLucasExcel]

I recommend using the FILTER function. Let's say the table is called City and has 2 columns, Column A City and Column B State and the dropdown list appears in cell D1. In D2 type =FILTER(City[City],City[State]=D1) Thanks for the question and feedback, I will work that in a future video.

[@sass1330]

What if I want to choose a project from the drop down list and then automatically get its progress? ​@@JasonLucasExcel