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