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

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