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

G

Guest

=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.
 
G

Guest

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)
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need a search/find/lookup function 4
Fill Down reference of even number rows 3
Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible? 10
Counting Results of Formulas 1
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
Changing Numerators but not Denominators 2
drop down list 3

Top