| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert a drop down list if a certain cell value is true
I use Windows XP.
What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
See if Debra Dalgleish's website helps:
Dependent Lists http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP-Pro "kd" wrote: I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
I wouldn't use the method Ron points to, it bis too complex for this
requirement IMO. Instead, this is my suggestion. Assuming list i is in E1, and the other lists are named ranges called numbers and letters, in the second dropdown, use an allow value of List and a formula of =IF(E1="A",letters,numbers) just change all the usual suspects to suit your siutuation. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kd" wrote in message ... I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
Hi Bob,
Pretty slick. Is there a way to do more than two lists with this method? I tried this and it did not work, validation would not accept it. =IF(E1="A",letters,numbers),IF(E1="C",costs) Regards, Howard "Bob Phillips" wrote in message ... I wouldn't use the method Ron points to, it bis too complex for this requirement IMO. Instead, this is my suggestion. Assuming list i is in E1, and the other lists are named ranges called numbers and letters, in the second dropdown, use an allow value of List and a formula of =IF(E1="A",letters,numbers) just change all the usual suspects to suit your siutuation. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kd" wrote in message ... I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
Hi Howard,
Yes, just a different formula format =IF(E1="A",letters,IF(E1="B",numbers,costs)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "L. Howard Kittle" wrote in message ... Hi Bob, Pretty slick. Is there a way to do more than two lists with this method? I tried this and it did not work, validation would not accept it. =IF(E1="A",letters,numbers),IF(E1="C",costs) Regards, Howard "Bob Phillips" wrote in message ... I wouldn't use the method Ron points to, it bis too complex for this requirement IMO. Instead, this is my suggestion. Assuming list i is in E1, and the other lists are named ranges called numbers and letters, in the second dropdown, use an allow value of List and a formula of =IF(E1="A",letters,numbers) just change all the usual suspects to suit your siutuation. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kd" wrote in message ... I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
Thanks for the info. That was the format I was trying to remember, having
seen it many times in other solutions. With two IF's you get three egg rolls. I should have been more concise and asked how do you do, four, six, or eight? Thanks, Howard "Bob Phillips" wrote in message ... Hi Howard, Yes, just a different formula format =IF(E1="A",letters,IF(E1="B",numbers,costs)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "L. Howard Kittle" wrote in message ... Hi Bob, Pretty slick. Is there a way to do more than two lists with this method? I tried this and it did not work, validation would not accept it. =IF(E1="A",letters,numbers),IF(E1="C",costs) Regards, Howard "Bob Phillips" wrote in message ... I wouldn't use the method Ron points to, it bis too complex for this requirement IMO. Instead, this is my suggestion. Assuming list i is in E1, and the other lists are named ranges called numbers and letters, in the second dropdown, use an allow value of List and a formula of =IF(E1="A",letters,numbers) just change all the usual suspects to suit your siutuation. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kd" wrote in message ... I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
insert a drop down list if a certain cell value is true
For more than 2 or 3 I like to use Choose. You can have up to 29 ranges. (29
reference arguments in Choose) =CHOOSE(MATCH(A1,J1:L1,0),Letters,Numbers,Costs) Choose can also handle dynamic ranges where Indirect can't and the "standard" workaround is "unecessarily overly complex" (IMO) Biff "L. Howard Kittle" wrote in message ... Thanks for the info. That was the format I was trying to remember, having seen it many times in other solutions. With two IF's you get three egg rolls. I should have been more concise and asked how do you do, four, six, or eight? Thanks, Howard "Bob Phillips" wrote in message ... Hi Howard, Yes, just a different formula format =IF(E1="A",letters,IF(E1="B",numbers,costs)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "L. Howard Kittle" wrote in message ... Hi Bob, Pretty slick. Is there a way to do more than two lists with this method? I tried this and it did not work, validation would not accept it. =IF(E1="A",letters,numbers),IF(E1="C",costs) Regards, Howard "Bob Phillips" wrote in message ... I wouldn't use the method Ron points to, it bis too complex for this requirement IMO. Instead, this is my suggestion. Assuming list i is in E1, and the other lists are named ranges called numbers and letters, in the second dropdown, use an allow value of List and a formula of =IF(E1="A",letters,numbers) just change all the usual suspects to suit your siutuation. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kd" wrote in message ... I use Windows XP. What I need to acheive is, when a value is selected from a drop down list, to return another dropdown list which matches the criteria, Ex. 1st list has 2 options, A&B and if A is selected return dropdown list which is related to A. Hope this explains... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| How do i insert a Address Bar kind of drop down list within MS Exc | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Hybrid Mode
