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

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

Any help in this would be greatly appreciated.