Drop downs value depended

[Dutchmaste]

I am trying to make a form in which there are multiple drop down menu's and they have to show a value depending on the value in the other cell.

Attached is a image on how the form looks a different worksheet in the same work book and a sample of how it should look when choosing in drop down menu's.

I hope it is possible to make the dropdown lists automated as in the data sheet new brands, models and colors are added constantly.

Hope my explanation and pictures are clear.

 

[Skovgaard]

Check below post

Dynamic drop-down lists

I need to create a drop-down list where the options depend on the value selected in another drop-down list. I used to do this regularly but it has been at least 10 years. Of course, there are probably easier ways to do it now. The way I remember doing it had something to do with the items in the...

www.mrexcel.com

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Dutchmaste]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thank you and done

 

[Fluff]

Thanks for that, you can do it along the lines of

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	County	District	Ward
2	Bedfordshire	Luton	Saints		Bedfordshire	Hackney	Hounslow Central		Greater London
3	East Sussex	Brighton and Hove	Hollingdean		East Sussex	Hounslow	Heston East		Hounslow
4	Cambridgeshire	East Cambridgeshire	Burwell		Cambridgeshire	Haringey			Heston East
5	West Yorkshire	Leeds	Bramley		West Yorkshire	Harrow
6	Hampshire	Test Valley	Cupernham		Hampshire	Brent
7	Staffordshire	Stafford	Coton abc		Staffordshire
8	Greater London	Hackney	Lea Bridge		Greater London
9	Hertfordshire	East Hertfordshire	Hertford Castle		Hertfordshire
10	Wiltshire	Swindon	Gorse Hill		Wiltshire
11	Greater London	Hounslow	Hounslow Central		West Sussex
12	West Sussex	Horsham	Steyning		Berkshire
13	Berkshire	Windsor	Boyn Hill		Nottinghamshire
14	Nottinghamshire	Rushcliffe	Bingham East		Merseyside
15	Merseyside	St. Helens	Newton		Norfolk
16	Norfolk	King's Lynn	Fairstead		East Riding of Yorkshire
17	Hertfordshire	Stevenage	Old Town		Essex
18	East Riding of Yorkshire	Kingston upon Hull	Avenue		Tyne and Wear
19	Berkshire	Windsor	Cox Green		West Midlands
20	Hampshire	Test Valley	Alamein		Cumbria
21	Essex	Colchester	Wivenhoe		Greater Manchester
22	Berkshire	West Berkshire	Calcot		Derbyshire
23	Tyne and Wear	Newcastle upon Tyne	Elswick
24	West Midlands	Walsall	Bloxwich West
25	Greater London	Haringey	Seven Sisters
26	Cumbria	Allerdale	Seaton
27	Greater London	Harrow	Belmont
28	Greater London	Haringey	White Hart Lane
29	Greater Manchester	Bolton	Halliwell
30	West Midlands	Walsall	Pleck
31	Greater London	Brent	Fryent
32	Bedfordshire	Luton	Biscot
33	Derbyshire	High Peak	New Mills East
34	Greater London	Hounslow	Heston East
35
Main

Cell Formulas
Range	Formula
E2:E22	E2	=UNIQUE(FILTER(A2:A1000,A2:A1000<>""))
F2:F6	F2	=UNIQUE(FILTER(B2:B1000,A2:A1000=I2))
G2:G3	G2	=UNIQUE(FILTER(C2:C1000,(A2:A1000=I2)*(B2:B1000=I3)))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
I2	List	=E2#
I3	List	=F2#
I4	List	=G2#

 

[Dutchmaste]

Thanks for that, you can do it along the lines of

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	County	District	Ward
2	Bedfordshire	Luton	Saints		Bedfordshire	Hackney	Hounslow Central		Greater London
3	East Sussex	Brighton and Hove	Hollingdean		East Sussex	Hounslow	Heston East		Hounslow
4	Cambridgeshire	East Cambridgeshire	Burwell		Cambridgeshire	Haringey			Heston East
5	West Yorkshire	Leeds	Bramley		West Yorkshire	Harrow
6	Hampshire	Test Valley	Cupernham		Hampshire	Brent
7	Staffordshire	Stafford	Coton abc		Staffordshire
8	Greater London	Hackney	Lea Bridge		Greater London
9	Hertfordshire	East Hertfordshire	Hertford Castle		Hertfordshire
10	Wiltshire	Swindon	Gorse Hill		Wiltshire
11	Greater London	Hounslow	Hounslow Central		West Sussex
12	West Sussex	Horsham	Steyning		Berkshire
13	Berkshire	Windsor	Boyn Hill		Nottinghamshire
14	Nottinghamshire	Rushcliffe	Bingham East		Merseyside
15	Merseyside	St. Helens	Newton		Norfolk
16	Norfolk	King's Lynn	Fairstead		East Riding of Yorkshire
17	Hertfordshire	Stevenage	Old Town		Essex
18	East Riding of Yorkshire	Kingston upon Hull	Avenue		Tyne and Wear
19	Berkshire	Windsor	Cox Green		West Midlands
20	Hampshire	Test Valley	Alamein		Cumbria
21	Essex	Colchester	Wivenhoe		Greater Manchester
22	Berkshire	West Berkshire	Calcot		Derbyshire
23	Tyne and Wear	Newcastle upon Tyne	Elswick
24	West Midlands	Walsall	Bloxwich West
25	Greater London	Haringey	Seven Sisters
26	Cumbria	Allerdale	Seaton
27	Greater London	Harrow	Belmont
28	Greater London	Haringey	White Hart Lane
29	Greater Manchester	Bolton	Halliwell
30	West Midlands	Walsall	Pleck
31	Greater London	Brent	Fryent
32	Bedfordshire	Luton	Biscot
33	Derbyshire	High Peak	New Mills East
34	Greater London	Hounslow	Heston East
35
Main

Cell Formulas
Range	Formula
E2:E22	E2	=UNIQUE(FILTER(A2:A1000,A2:A1000<>""))
F2:F6	F2	=UNIQUE(FILTER(B2:B1000,A2:A1000=I2))
G2:G3	G2	=UNIQUE(FILTER(C2:C1000,(A2:A1000=I2)*(B2:B1000=I3)))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
I2	List	=E2#
I3	List	=F2#
I4	List	=G2#

When I try this I get #SPILL! return when entering Cell formula for E2:E22

 

[Dutchmaste]

Check below post

Dynamic drop-down lists

I need to create a drop-down list where the options depend on the value selected in another drop-down list. I used to do this regularly but it has been at least 10 years. Of course, there are probably easier ways to do it now. The way I remember doing it had something to do with the items in the...

www.mrexcel.com

Works like charm for two drop down menu's. But I am having issues figuring out the formula for the third drop down menu

 

[Fluff]

When I try this I get #SPILL! return when entering Cell formula for E2:E22

Clear all cells in E2 & below & then copy the formula back into E2 only.

 

[Dutchmaste]

Clear all cells in E2 & below & then copy the formula back into E2 only.

My bad that worked, thank you so much for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.