Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement with lists and dropdowns
Can you make an if statement that will choose a certain set of cells for dropdown lists if true and another set of cells for a dropdown lists if false? and how can you make an if statement create a dropdown list? Say A1="Yes" B1's drop down list will consist of: Apple Pear Peach these choices would be found in D1:D3 and if A1="No" B1's drop down list will consist of Pepper Tomato Cabbage these choices would be found in E1:E3 Just wondering if this is possible -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=380630 |
#2
|
|||
|
|||
Debra Dalgleish shows how to do this with Data|Validation.
http://www.contextures.com/xlDataVal02.html malik641 wrote: Can you make an if statement that will choose a certain set of cells for dropdown lists if true and another set of cells for a dropdown lists if false? and how can you make an if statement create a dropdown list? Say A1="Yes" B1's drop down list will consist of: Apple Pear Peach these choices would be found in D1:D3 and if A1="No" B1's drop down list will consist of Pepper Tomato Cabbage these choices would be found in E1:E3 Just wondering if this is possible -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=380630 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|