Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |