How do I make the true return a drop down list in the IF function?

=IF(B10="TWILL SHIRT",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 &
other results (right column)

"Brian" wrote:

> =IF(B10="TWILL SHIRT",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.

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.

"Duke Carey" wrote:

> 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 &
> other results (right column)
>
> "Brian" wrote:
>
> > =IF(B10="TWILL SHIRT",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.

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

Debra Dalgliesh's Data Validation basics

http://www.contextures.com/xlDataVal01.html

Dependent dropdowns...
http://www.contextures.com/xlDataVal02.html



"Brian" wrote:

> 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.
>
> "Duke Carey" wrote:
>
> > 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 &
> > other results (right column)
> >
> > "Brian" wrote:
> >
> > > =IF(B10="TWILL SHIRT",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.

AWESOME!.....Thanks.

"Duke Carey" wrote:

> Debra Dalgliesh has a detailed explanation for doing just that at her site
>
> Debra Dalgliesh's Data Validation basics
>
> http://www.contextures.com/xlDataVal01.html
>
> Dependent dropdowns...
> http://www.contextures.com/xlDataVal02.html
>
>
>
> "Brian" wrote:
>
> > 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.
> >
> > "Duke Carey" wrote:
> >
> > > 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 &
> > > other results (right column)
> > >
> > > "Brian" wrote:
> > >
> > > > =IF(B10="TWILL SHIRT",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.

Brian

Follow Debra's instructions for creating "dependent lists"

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 13 Apr 2006 12:14:01 -0700, Brian <[email protected]>
wrote:

>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.
>
>"Duke Carey" wrote:
>
>> 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 &
>> other results (right column)
>>
>> "Brian" wrote:
>>
>> > =IF(B10="TWILL SHIRT",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.