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