Variable dropdown menus

Hello Adam,

Thank you for your question. The best solution would be to use two drop-downs. One to change the list from which the final drop-down list comes and one for the final drop-down list. To see how, please copy the link below and paste it into your web browser's address bar. This explains it very well with an example. You need to use an hlookup or a vlookup, depending on the layout of your data.

http://www.excelfunctions.net/Variable-Drop-Down-List.html

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer