It is very simple to create dependent drop down list in excel. Check out the below link and follow the steps,

http://snpinfotech.wordpress.com/201...ists-in-excel/