Can I include a "validation drop down" in a conditional statement?
 

I'm using Excel 2003 and trying to set up a situation where an "If" statement
would allow me to place a "validation drop down list" in the cell if the
conditions of the if statement return a logical "true".

That is, if I'm in cell B2, and my conditional is "=if(A20,XYZ,0), and cell
A2 equals 1, I want to substitute a validation drop down for XYZ in the
statement.

Does anyone know if this is possible?

Thanks,

Can I include a "validation drop down" in a conditional statement?
 

What are you really trying to do?

A validation dropdown isn't appropriate here, since it won't give the
user a chance to change it while the cell is calculated...

You could put the dropdown in another cell (say, C2) and use *that*:

B2: =IF(A20,C2,0)



In article ,
JanW wrote:

I'm using Excel 2003 and trying to set up a situation where an "If" statement
would allow me to place a "validation drop down list" in the cell if the
conditions of the if statement return a logical "true".

That is, if I'm in cell B2, and my conditional is "=if(A20,XYZ,0), and cell
A2 equals 1, I want to substitute a validation drop down for XYZ in the
statement.

Does anyone know if this is possible?

Thanks,