Repeated Values in Data Validation

[Ohrdhor]

I'm having problems creating drop down lists in excel via Data Validation, more specifically I have lists with repeated values and I am unsure of how I can link my lists without confusing the database. Currently I am using =INDIRECT as my means of linking lists.

I suppose the easiest way to explain this is with an example:

Lets say I have 3 Brands, of which there is a further subset, Type, and a further subset of Model.

"BrandA", which has 3 types of Type, Tall, Fat, and Skinny
"BrandB" has 4 Types, Tall Fat Skinny and Rotund
"BrandC" only has Tall and Rotund

Each of the models are dependant on the Type, however when I select Tall for "BrandA" I get the list of all of "BrandA"'s Tall Models, but also I get all of "BrandB"'s and "BrandC"'s Tall Models as well. How can I make it so that I would only get "BrandA"'s models?

I hope my example was clear enough, if not I can attempt to elaborate further, and if it wasn't evident already, I'm not the most excel savvy gentleman.

Thanks in advance guys!

 

[T. Valko]

I'm having problems creating drop down lists in excel via Data Validation, more specifically I have lists with repeated values and I am unsure of how I can link my lists without confusing the database. Currently I am using =INDIRECT as my means of linking lists.

I suppose the easiest way to explain this is with an example:

Lets say I have 3 Brands, of which there is a further subset, Type, and a further subset of Model.

"BrandA", which has 3 types of Type, Tall, Fat, and Skinny
"BrandB" has 4 Types, Tall Fat Skinny and Rotund
"BrandC" only has Tall and Rotund

Each of the models are dependant on the Type, however when I select Tall for "BrandA" I get the list of all of "BrandA"'s Tall Models, but also I get all of "BrandB"'s and "BrandC"'s Tall Models as well. How can I make it so that I would only get "BrandA"'s models?

I hope my example was clear enough, if not I can attempt to elaborate further, and if it wasn't evident already, I'm not the most excel savvy gentleman.

Thanks in advance guys!

See if this helps:

http://contextures.com/xlDataVal02.html