MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pull down lists


Posted by Jorge Boone on September 17, 2001 2:22 PM

I am looking for a way to select a pull down list from seleting a topic from a pull down list in another cell.

Example:

I have a pull down list with the following: Cars, Planes and Boats
If I select Boats the pull down list next to it will have Boat motors, oars and paddles

but if I had selected Planes the list next to might have wings, Boeing parts and tail.

Please help me. Thanks


Posted by IML on September 17, 2001 2:56 PM

List all the parts you want to appear "Plane" somewhere. Name the range PLANE via the name box.
Repeat this for boats,cars etc.
Assuming A1 is your drop down for boats/planes etc, your next drop down could be set with validation set up to list and under source, type the formula
=INDIRECT(A1)
good luck

Posted by Jorge Boone on September 18, 2001 12:46 PM

Thanks,

It worked like a charm