Have you ever wanted to create a two-level data validation list? This simple trick will help you create two-level or cascading drop-down validation lists in Excel. All you need is some data, a pivot table, and simple IF formulas. Watch the video to understand the process.

For a sample file and further details, see:

https://chandoo.org/wp/two-level-drop-downs/

#MsExcelTricks #DropDownLists

More videos and help on data validation in Excel:
How to create a dropdown menu for data validation in Excel – https://chandoo.org/wp/excel-add-drop-down-list/

Data validation without duplicates – https://youtu.be/4Rv5twNqrGM
Cascading dropdown menus in Excel – https://youtu.be/QPcC0WVjsTI

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.