IF Statement with LISTs

[jay-excel]

Hello,

I was wondering if it were possible to use a conditional statement for lists.
I am trying to have it so that the list in D6 changes based on the cell value in C6.

In C6 I have a list that has three options "-","NS","PE."

I would like it that when one of these three is chosen in C6 then a list for the corresponding choice is available in the cell D6.

So for example, if "NS" is chosen in C6, then "A,B,C,D,E" is available in a drop-down list in D6.

And if "PE" is chosen in C6 then "1,2,3,4,5" is available in a drop-down list in D6.

And if "-" is chosen in "C6" then only "-" is available in D6.

Any suggestions would be greatly appreciated!

Thanks,

Jay

 

[Andrew Poulsom]

Look here:

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