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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>