How to create 2 different drop down list based on 1st drop down list

[phantasmyh]

Model	spec	colour
model 1	a	b	c	white	black	grey
model 2	a	d	e	green	white	blue
model 3	c	f	g	yellow	red	black

<colgroup><col span="7"></colgroup><tbody>
</tbody>

Is that anyway to create the 2nd(spec) and 3rd(colour) drop down list base on the selection of 1st drop downlist(Model)?

 

[Rijnsent]

Hi Phantasmyh,
try: https://www.excel-easy.com/examples/dependent-drop-down-lists.html or https://www.contextures.com/xlDataVal02.html
Cheers,
Koen

 

[phantasmyh]

Hi Phantasmyh,
try: https://www.excel-easy.com/examples/dependent-drop-down-lists.html or https://www.contextures.com/xlDataVal02.html
Cheers,
Koen

Thanks, the 1st link contain wht i looking for