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

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

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

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

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

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

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

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

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

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

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

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