Drop down question

[Purplerose]

Hi .. I am trying to create a drop down of lets say toys where I have the option of choosing the color.

So, I have 10 toys .. each of these ten toys are available in a range of colors. Not all toys have the same colors available. I need to be able to select a drop-down list for the toy #1 and from there only see the colors available for that toy. Can a drop down have variables?

 

[Fluff]

You need dependant data validation, have a look here https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/