Make 2 AND 3 levels of dependent data validation lists in multiple rows. It's super easy to set up with named ranges.
TIMESTAMPS
0:00 What are dependent dropdown lists?
0:40 Prepare data (named ranges)
1:15 Insert level 1 dropdown lists
1:47 Insert level 2 dropdown lists
3:34 Dependent dropdown lists in 3 levels
4:03 Level 1 dropdown lists (for 3 levels)
4:17 Prepare data for 3 levels
5:18 Level 2 dropdown lists (for 3 levels)
5:52 Level 3 dropdown lists
LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
FREE COURSES
Try my free 30minute Excel course and join 100,000+ students: https://spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: https://spreadsheeto.com/freepowerb...
PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: https://spreadsheeto.com/zerotohero/
VBA Masterclass. Become a VBA pro in 20 hours: https://spreadsheeto.com/vbamastercl...
Power BI Essentials. Master Power BI in 12 hours: https://spreadsheeto.com/powerbi/
HIRE ME AND MY TEAM
We develop custom Excel systems: https://spreadsheeto.com/excelconsul...