Excel Data Validation Lists

[Cameron_S]

Hoping someone can help me here..

I have a spreadsheet whereby I have a Column called 'Primary Caetgory'
and a second column called 'Secondary Category'.
I have a Data Validdation list drop down for the primary category
which lets you choose the cell contents from a list on another
worksheet.
What I want to be able to do is choose the primary category from the
drop down list, then have that narrow down the drop down list on my
secondary category based on the what the primary category is.

for example:

In cell A1, the drop down list might contain, 3 choices.. say Dogs,
Cats or People. I choose People. Then in the next column, I want a
similar drop down list, which looks up all the avavilable options
(secondary categories) for people from the other worksheet. eg.
Female, Male.

I've tried the long way, assigning names to each range, then using IF
statements for data validation conditions, but it's limited to 6
nested IF's, and doesn't seem to be the best approach.

Any help would be greatly appreciated.
Thanks
Cameron_S

 

[Debra Dalgleish]

There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html

 

[Cameron_S]

Thank you very much.. I did find this document shortly after posting, and it
explained it VERY well.. Problem solved.

Thanks again.

Cameron_S

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know that it helped.