Conditional Data Validation Lists

[benm7]

Hi guys,

I am trying to create a table that allows me to select values from a list and that value then filters what I can select in the next drop down and so on.

Example: I have a reference sheet that looks like the below, which contains all my data. On a separate sheet I want to be able to select my material from the options in the reference sheet, which then filters my available options on the type, followed by length, then width, which will then give me the price as shown in the reference sheet.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Material[/TD]
[TD]Type[/TD]
[TD]Length (cm)[/TD]
[TD]Width (cm)[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Wood[/TD]
[TD]Pine[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Wood[/TD]
[TD]Pine[/TD]
[TD]100[/TD]
[TD]80[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Wood[/TD]
[TD]Pine[/TD]
[TD]200[/TD]
[TD]80[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]Wood[/TD]
[TD]Oak[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]Metal[/TD]
[TD]Aluminium[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Metal[/TD]
[TD]Aluminium[/TD]
[TD]200[/TD]
[TD]80[/TD]
[TD]350[/TD]
[/TR]
[TR]
[TD]Metal[/TD]
[TD]Stainless Steel[/TD]
[TD]300[/TD]
[TD]50[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]

I have done this before but it was years ago and simply cannot remember how to do it!

Thanks all,
Ben

 

[cooper645]

There is a tutorial elsewhere for this;

http://www.excel-easy.com/examples/dependent-drop-down-lists.html

i think this is what you are after