I believe you can easily achieve your goal using the Power Dropdown Excel add-in. You can find it inside Excel, using the Add-ins button or get it from Appsource. You can try it completely free of charge for up to 3 months.