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?

Location	Equipment
Dry Room	Dryer
Dry Room	Sink
Changing Room	Locker 1
Changing Room	Locker 2
Changing Room	Locker 3
Changing Room	Locker 4
Changing Room	Show Rack

<tbody>
</tbody>

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