|
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. |
How do I make the true return a drop down list in the IF function?
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. |
How do I make the true return a drop down list in the IF funct
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. |
How do I make the true return a drop down list in the IF funct
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. |
How do I make the true return a drop down list in the IF funct
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. |
How do I make the true return a drop down list in the IF funct
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 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. |
| All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com