Data Validation with Multiple option in drop downs

[cell-dweller]

Hi
Hope someone can help me make sense with this. I have a list of products (models) that come in different sizes and multiple colours.
I would like to be able to create a drop down list that is able to take into account the various options.
I have attached a sample of the sheet. I can figure out the Model option (by using a list and Data validation) and the same with the Size....but not sure how to allow for multiple sizes of a certain model, and then also multiple colours for each model.

Thanks for any assistance on this.

[Glenn Kennedy]

On how many rows (maximum) do you need to have the drop-downs (row 14) repeated?

Also, please amend your profile to show us the excel version you are using AND your location in the world. BOTH are required to ensure that version compatabilities/regional settings can be taken into account. Your current entry tells us NOTHING useful.

[avk]

One way you can do this.
I modify your data structure.
Insert table range.
Create Data Validation List
Look attach file.

[cell-dweller]

Thanks AVK
I guess i could use this, and will make sense, although the drop down could get quite long. I was trying to keep the drop down options up to a max of about 5