Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Bear with me I know what I want but don't know how to express it.
For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Leisl
Check out: http://www.contextures.com/excelfiles.html#DataVal. You should find what you need here. Mike Rogers "Leisl" wrote: Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Data Validation/ List/ Source:
=IF(A1="dog",$A$17:$C$17,IF(A1="cat",$A$18:$C$18,$ A$19:$C$19)) where you 3 lists are $A$17:$C$17 for dogs, $A$18:$C$18 for cats, & $A$19:$C$19 for horses. -- David Biddulph "Leisl" wrote in message ... Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
There are description how to make a dependent validation here
http://www.contextures.com/xlDataVal02.html Regards, Peo Sjoblom Leisl wrote: Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Hi, thank you for trying but this doesn't help. Anyone else have any
suggestions? "Mike Rogers" wrote: Leisl Check out: http://www.contextures.com/excelfiles.html#DataVal. You should find what you need here. Mike Rogers "Leisl" wrote: Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Brilliant, thank you.
"David Biddulph" wrote: Data Validation/ List/ Source: =IF(A1="dog",$A$17:$C$17,IF(A1="cat",$A$18:$C$18,$ A$19:$C$19)) where you 3 lists are $A$17:$C$17 for dogs, $A$18:$C$18 for cats, & $A$19:$C$19 for horses. -- David Biddulph "Leisl" wrote in message ... Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
if functions involving drop down lists.
Yes it does, and it is a less messy solution, no offense to the person
that posted the one you said worked but the solution described in the link gives you much more flexibility. No need for any IF formulas. Regards, Peo Sjoblom Leisl wrote: Hi, thank you for trying but this doesn't help. Anyone else have any suggestions? "Mike Rogers" wrote: Leisl Check out: http://www.contextures.com/excelfiles.html#DataVal. You should find what you need here. Mike Rogers "Leisl" wrote: Bear with me I know what I want but don't know how to express it. For example in cell A1 i have created a drop down list, lets say dog, cat, horse. In cell B1 i want to create an if function so that if "dog" is selected in A1 then B1 will give me the option of a 2nd drop down list saying spaniel, doberman and pointer BUT if I select "cat" in cell A1 then I want B1 to give me the option of a drop down list of persian, siamese or moggy but not spaniel, doberman and pointer. Equally if "horse" is selected in A1 then i want B1 to give me the option of race horse, showjumper or pony and not spaniel, doberman, siamese etc... I have already created the lists further down on the sheet with the data I want to include. Hope I have explained this ok. Thank you in advance for any help. Regards. Leisl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists | New Users to Excel | |||
Setting up conditional drop down lists in Excel 2003? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
drop down lists | New Users to Excel | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) |