In Excel, how do you select one option from a list that allows you to choose a sub list.

This one has always puzzled me. How to create a drop down that leads to the a sub list. So this video explains it. We used several Excels tools to achieve this including: Data Validation Indirect Name Manager #excel #exceltips #datavalidation #exceltutorial #excelformula