Conditional Data Validation

[Raddad59]

Greetings,
I am trying to do something that I am not sure can be done.
I want to be able to have two drop down lists and based on the first list the range selected for the second drop down list is evaluated.

Example:
First list
Joe
Bob
Frank
Sue

Joe List
Blue
Green
Red

Bob List
Green
Violet
Purple

Frank List
Apples
Oranges

Now using a drop down list I select "Joe". Once Joe is selected a second drop down list in a different cell is selected and that list is from the "Joe List" range
If I select from the first list "Bob" and I go to the second drop down list the selections for Bob appear. and so on...

I hope there is a solution to this. Ultimately I will have 10 lists based on the first list. I realize that I could do this with conditional IF statements but i am working with Excel 2003 and there is a limit of 7 nested IF statements. I would need 10 for the project to work correctly.

Thanks for your help
Joe

 

[jeffreybrown]

Hi Joe and Welcome to the Board,

I think you could use this or even this