pull downs and variables

D

darqphire

I wish to have a pull down menu containing 15 choices each of whic
would cause a given groups of cells to display a list of pre-arrange
text.

Ex: choose "A" from pulldown in (C2); and (D16) through (D35) woul
display a custom list.... but if you choose "B" from the pulldown,
seperate list would appear instead...

Any help in this would be greatly appreciated
 
B

Bob Phillips

The way to do this is as follows

The lists to use in D16:D35 should be entered as list in separate ranges,
and all named using a naming convention, such as List1, List2, List3, or say
ListEurope,ListAsia, ListAFrica, etc., where the 1,2,3 or Europe, Asia,
Africa are the values that will be selectable in the C2 list.

Then in DV in D16:D35, set the DV to an allow type of 'List', and use a
formula of

=INDIRECT("List"&C2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top