Data validation problem

[Peter1999]

Hi,

Attached you will find the S&P industry table (from their website) in
raw form, that is the main industries according to GICS, and the main
subindustry division. Now what I need to create, is a data validation
list on sheet 2 that selects the industry (as in bold), and another
validation list that applies a data validation list based on the first
choice. In other words, if you would choose "Healthcare Supplies &
Services" in box one, you would only be able to choose among the
subindustries within that sector in box two.
I hope someone understands what I am trying to build here, I'm really
struggling.

Thanks,

Peter


+-------------------------------------------------------------------+
|Filename: excel question.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4789 |
+-------------------------------------------------------------------+

 

[Guest]

Take a look here on how to create dependent Data Validation lists:

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

HTH

 

[JB]

http://cjoint.com/?ftnEgMZ6Ey

Dépendants Data /Validation List
You may Add items in Columns oand Rows whitout modification

1ere list in B2:=Offset($F$1;;;;Counta($F$1:$Z$1))

2e list in
B5:=Offset($F$2;;Match(B2;$F$1:$Z$1;0)-1;Counta(Offset(F:F;;Match(B2;$F$1:$Z$1;0)-1))-1)

If list on another sheet:
choice1:=Listes!$F$1:$Z$1
choice2:=Listes!$F:$F

1ere liste in B2:=Offset(Choix1;;;;CountA(Choice1))
2e liste in B5:
=Offset(choixce;1;Match(B2;Choice1;0)-1;CountA(Offset(choice2;;Match(B2;Choice1;0)-1))-1)

Cordialy JB

 

[Peter1999]

Thanks, that works perfectly, although I don't exactly understand how..
Thanks a lot