November 9, 2016
December 7, 2016
Your example is not showing the expected result you want, but I assume you want to create dependent data validation lists. Check out the link below for one example on how to do it. There are other techniques, but as I don’t know what Excel version you have the technique used in the linked article will do fine.