Please help to achieve a drop down list based on the result of another cell.

[danwaddy]

Hi all,

hope you can help... I have a cell that has a list of locations to select from. Once selected, in the cell next to it i need for it to again have a drop down list of equipment that is in the location selected.

I have created tables with these lists in already in a different sheet. i've given an example of the information below.

I've managed to create the drop down list in the first cell but i have no idea how to achieve what i need in the second cell..

can you help please?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Location[/TD]
[TD="align: center"]Equipment[/TD]
[/TR]
[TR]
[TD]Dry Room[/TD]
[TD]Dryer[/TD]
[/TR]
[TR]
[TD]Dry Room[/TD]
[TD]Sink[/TD]
[/TR]
[TR]
[TD]Changing Room[/TD]
[TD]Locker 1[/TD]
[/TR]
[TR]
[TD]Changing Room[/TD]
[TD]Locker 2[/TD]
[/TR]
[TR]
[TD]Changing Room[/TD]
[TD]Locker 3[/TD]
[/TR]
[TR]
[TD]Changing Room[/TD]
[TD]Locker 4[/TD]
[/TR]
[TR]
[TD]Changing Room[/TD]
[TD]Show Rack[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Many thanks
Dan

 

[AlphaFrog]

You want to create a Dependent DropDown List.

This link is a step-by-step guide...
Create Dependent Drop Down Lists

 

[danwaddy]

You want to create a Dependent DropDown List.

This link is a step-by-step guide...
Create Dependent Drop Down Lists

Thanks, id tried to use that before but couldnt get my head around it. i know realise it was because i was using spaces in table tiles. thanks for the help