Drop down list with an if statement
 

Is is possible to use a drop down list in connection with a if statement? I
have a worksheet with a drop down list in column one. Depending on what is
selected in column one, there are a number of selections (drop down lists) in
column two.

There are instructions here for dependent data validation lists:

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

khelton wrote:
Is is possible to use a drop down list in connection with a if statement? I
have a worksheet with a drop down list in column one. Depending on what is
selected in column one, there are a number of selections (drop down lists) in
column two.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

This file might be a help:
http://www.bygsoftware.com/examples/...d_indirect.zip
It's in the "Worksheet (No VBA)" section on page:
http://www.bygsoftware.com/examples/examples.htm

Shows how using "Data Validation" and "INDIRECT()" you can populate a cell
from two dependant lists


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"khelton" wrote in message
...
Is is possible to use a drop down list in connection with a if statement?
I
have a worksheet with a drop down list in column one. Depending on what
is
selected in column one, there are a number of selections (drop down lists)
in
column two.