Download the featured file here: http://www.bluepecantraining.com/portfolio/cascading-drop-down-lists-in-excel/

This video shows you how to set up dependent, multilevel drop down menus in Excel - when you select a value from the first drop down list, Excel will show the relevant values in a second drop down. You will learn about naming ranges, data validation and the INDIRECT function. Hope it helps!
------------------------