Validation List

[FrodeOlsen]

Got a problem with a Validation List issue, and i figured this Group
should be able to come up with a simple solution.

I got this Spreadsheet that i will use to "parse/code/de-code"
information in. And I got some Values that I have in a differend
Worksheet.

Problem:
I have 13 differnt "Class" categories, and each of them got 3-20
Sub-Classes. However if i choose Class 1, I like to ONLY get the
Sub-Classes for Class 1 in a Validation List.

Tried with IF("InputCell" = "Class1Name","Class1Sub-ClassRange", "") it
work..but only to Class 7...

 

[Debra Dalgleish]

You can create dependent data validation lists. There are instructions
here:

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

 

[FrodeOlsen]

Thanks for that helpfull tip Debra, however it do not help me in this
case.

My "Validation List" do not have only "one word values", in fact most
of them have multiple up to 70carracters. And I have about 15 Main and
150 sub-Catagories that i need to sort. And as you might understand I
dont want all 150 sub-Cat. to show up on all 15 main Cat.

Got any other suggestions?

 

[Debra Dalgleish]

The link that I posted included instructions for dependent lists with
multiple word items:

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

 

[FrodeOlsen]

Sorry I guess i dident read everything.

Thanks again.