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

G

Guest

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(A2>0,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,
 
J

JE McGimpsey

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(A2>0,C2,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation in a Conditional Statement 2
Remove blank cells from data validation drop down box 3
Data Validation w/an If Statement 1
adding a drop down list to an If Statement? 1
conditional data validation 6
Conditional Formatting - Comparing 2 columns 1
How do I create a drop down box within a drop down box? 1
How to have conditional dropdown 1

Top