MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Drop Down Box Values


Posted by Andrea on October 12, 2001 5:46 AM

I am trying to create two drop down lists that when a value is selected in one cell, the second list automatically looks to specific data that is related to the selection in the first cell. Any help is greatly appreciated!


Posted by IML on October 12, 2001 6:36 AM

Lets say your first cell is A1. Your validation calls for two values (dog,cat).
List all the entries you want to allow for say dog (beagle,hound, lab), in a range and name it "dog" via the name box. repeat for all your entries allowed in A1.
For you validation in B2, allow for list. Type the following in the source box
=INDIRECT(A1)

Good luck