software

=IF(B10=quot;TWILL SHIRTquot;,M2,0)

B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Please don't use ALL caps - it's like shouting

Use

=vlookup(B10, D1:E15,2,false)

where D1:E15 is a table of dropdown items (left column) and Twill Shirt amp;
other results (right column)

quot;Brianquot; wrote:

gt; =IF(B10=quot;TWILL SHIRTquot;,M2,0)
gt;
gt; B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
gt; DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Sorry about the caps...

What I'm looking for is ...there is a drop down list in B10.
I want to get another drop down list in C10, a different drop down list for
each different item when selected in B10.

ie: if you choose Twill Shirt in B10, then drop down list of Twill Shirt
colors appears in C10, if you choose Polo Shirt in B10, then drop down list
of Polo Shirt colors appears in C10, etc.

quot;Duke Careyquot; wrote:

gt; Please don't use ALL caps - it's like shouting
gt;
gt; Use
gt;
gt; =vlookup(B10, D1:E15,2,false)
gt;
gt; where D1:E15 is a table of dropdown items (left column) and Twill Shirt amp;
gt; other results (right column)
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; =IF(B10=quot;TWILL SHIRTquot;,M2,0)
gt; gt;
gt; gt; B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
gt; gt; DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Debra Dalgliesh has a detailed explanation for doing just that at her site

Debra Dalgliesh's Data Validation basics

www.contextures.com/xlDataVal01.html

Dependent dropdowns...
www.contextures.com/xlDataVal02.html
quot;Brianquot; wrote:

gt; Sorry about the caps...
gt;
gt; What I'm looking for is ...there is a drop down list in B10.
gt; I want to get another drop down list in C10, a different drop down list for
gt; each different item when selected in B10.
gt;
gt; ie: if you choose Twill Shirt in B10, then drop down list of Twill Shirt
gt; colors appears in C10, if you choose Polo Shirt in B10, then drop down list
gt; of Polo Shirt colors appears in C10, etc.
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; Please don't use ALL caps - it's like shouting
gt; gt;
gt; gt; Use
gt; gt;
gt; gt; =vlookup(B10, D1:E15,2,false)
gt; gt;
gt; gt; where D1:E15 is a table of dropdown items (left column) and Twill Shirt amp;
gt; gt; other results (right column)
gt; gt;
gt; gt; quot;Brianquot; wrote:
gt; gt;
gt; gt; gt; =IF(B10=quot;TWILL SHIRTquot;,M2,0)
gt; gt; gt;
gt; gt; gt; B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
gt; gt; gt; DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

AWESOME!.....Thanks.

quot;Duke Careyquot; wrote:

gt; Debra Dalgliesh has a detailed explanation for doing just that at her site
gt;
gt; Debra Dalgliesh's Data Validation basics
gt;
gt; www.contextures.com/xlDataVal01.html
gt;
gt; Dependent dropdowns...
gt; www.contextures.com/xlDataVal02.html
gt;
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Sorry about the caps...
gt; gt;
gt; gt; What I'm looking for is ...there is a drop down list in B10.
gt; gt; I want to get another drop down list in C10, a different drop down list for
gt; gt; each different item when selected in B10.
gt; gt;
gt; gt; ie: if you choose Twill Shirt in B10, then drop down list of Twill Shirt
gt; gt; colors appears in C10, if you choose Polo Shirt in B10, then drop down list
gt; gt; of Polo Shirt colors appears in C10, etc.
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; Please don't use ALL caps - it's like shouting
gt; gt; gt;
gt; gt; gt; Use
gt; gt; gt;
gt; gt; gt; =vlookup(B10, D1:E15,2,false)
gt; gt; gt;
gt; gt; gt; where D1:E15 is a table of dropdown items (left column) and Twill Shirt amp;
gt; gt; gt; other results (right column)
gt; gt; gt;
gt; gt; gt; quot;Brianquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =IF(B10=quot;TWILL SHIRTquot;,M2,0)
gt; gt; gt; gt;
gt; gt; gt; gt; B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
gt; gt; gt; gt; DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.

Brian

Follow Debra's instructions for creating quot;dependent listsquot;

www.contextures.on.ca/xlDataVal02.htmlGord Dibben MS Excel MVP

On Thu, 13 Apr 2006 12:14:01 -0700, Brian gt;
wrote:

gt;Sorry about the caps...
gt;
gt;What I'm looking for is ...there is a drop down list in B10.
gt;I want to get another drop down list in C10, a different drop down list for
gt;each different item when selected in B10.
gt;
gt;ie: if you choose Twill Shirt in B10, then drop down list of Twill Shirt
gt;colors appears in C10, if you choose Polo Shirt in B10, then drop down list
gt;of Polo Shirt colors appears in C10, etc.
gt;
gt;quot;Duke Careyquot; wrote:
gt;
gt;gt; Please don't use ALL caps - it's like shouting
gt;gt;
gt;gt; Use
gt;gt;
gt;gt; =vlookup(B10, D1:E15,2,false)
gt;gt;
gt;gt; where D1:E15 is a table of dropdown items (left column) and Twill Shirt amp;
gt;gt; other results (right column)
gt;gt;
gt;gt; quot;Brianquot; wrote:
gt;gt;
gt;gt; gt; =IF(B10=quot;TWILL SHIRTquot;,M2,0)
gt;gt; gt;
gt;gt; gt; B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
gt;gt; gt; DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.