How to make a list conditional upon another list?

[RedMisterExcel]

Hey guys, potentially dumb question, but I want to create a drop-down list that can spawn a selection of further drop-down lists from another cell contingent on the entry in the first list.

For example: List A = Fruit, Vegetables, Drinks

List B can be one of these three depending on which of the entries in List A was selected first: Apples, Oranges, Bananas; Celery, Broccoli, Carrots; or Pepsi, Coke, Sprite

Is that possible to do?

 

[Fluff]

I was talking about your profile on this site to show which version of Excel you are using.

 

[RedMisterExcel]

I was talking about your profile on this site to show which version of Excel you are using.

Oh lol, sorry.

But yeah, can anyone help in terms of creating a single drop down list, or is it not possible?

 

[RedMisterExcel]

MrExcelPlayground13.xlsx
	A	B	C	D	E
1	Item	Type	Type	Item	Fruit
2	Apple	Fruit	Fruit	Apple	Orange
3	Orange	Fruit	Vegetable	Orange
4	Banana	Fruit	Drink	Banana
5	Celery	Vegetable
6	Croccoli	Vegetable
7	Carrots	Vegetable
8	Pepsi	Drink
9	Coke	Drink
10	7up	Drink
Sheet20

Cell Formulas
Range	Formula
C2:C4	C2	=UNIQUE(B2:B10)
D2:D4	D2	=FILTER(A2:A10,B2:B10=E1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
E1	List	=C2#
E2	List	=D2#

Sorry friend, let me rephrase. Is it possible to create a dependent drop-down list for a single bar item, or do you have to create multiple secondary data validation lists?

For example if DV A says Fruits, then DV B lists apples, oranges, bananas. If DV A says Veggies, then DV B changes to carrots, bellpeppers, tomatoes. Is that possible or do I have to create DV C to account for veggies instead?

 

[Fluff]

Have a look here How to make a dependent (cascading) drop-down list in Excel

 

[RedMisterExcel]

Have a look here How to make a dependent (cascading) drop-down list in Excel

Thanks Mod, I'll have a look at that. Question- does underscore (_) trick Excel into thinkin two words are one word when adjusting the Name Box?

 

[Fluff]

No it doesn't.
Also please update your profile as requested.

 

[RedMisterExcel]

No it doesn't.
Also please update your profile as requested.

Copy