IF Statement with LISTs

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,118,122
Messages
5,570,313
Members
412,318
Latest member
angoeyuan
Top