| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function in drop down lists
Hi
Please bear with me, I know what I want I just can't explain it! I have created a drop down list in cell A1 of dog, cat or horse. If A1 selects "dog" then I want cell B1 to create a further drop down list of spaniel, doberman, retriever BUT if I select "cat" in cell A1 then I want cell B1 to create a drop down list of siamese, berman or moggy and NOT spaniel, doberman, retriever. Equally if I select "horse" in A1 then I want the drop down list in cell B1 to say racehorse, showjumper or pony and NOT spaniel, doberman, moggy etc. I have already created a list of dog, cat, horse in the spreadsheet and also lists for spaniel, doberman, retriever and then siamese, berman etc... Any advice gratefully received. Thank you in advance. Regards. Leisl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function in drop down lists
HI,
Assuming you have named your lists "dog", "cat" and "horse" then in B1 select "list" from the data validation menu and type: =INDIRECT(A1) HTH Jean-Guy "Leisl" wrote: Hi Please bear with me, I know what I want I just can't explain it! I have created a drop down list in cell A1 of dog, cat or horse. If A1 selects "dog" then I want cell B1 to create a further drop down list of spaniel, doberman, retriever BUT if I select "cat" in cell A1 then I want cell B1 to create a drop down list of siamese, berman or moggy and NOT spaniel, doberman, retriever. Equally if I select "horse" in A1 then I want the drop down list in cell B1 to say racehorse, showjumper or pony and NOT spaniel, doberman, moggy etc. I have already created a list of dog, cat, horse in the spreadsheet and also lists for spaniel, doberman, retriever and then siamese, berman etc... Any advice gratefully received. Thank you in advance. Regards. Leisl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function in drop down lists
Leisl wrote: Hi Please bear with me, I know what I want I just can't explain it! I have created a drop down list in cell A1 of dog, cat or horse. If A1 selects "dog" then I want cell B1 to create a further drop down list of spaniel, doberman, retriever BUT if I select "cat" in cell A1 then I want cell B1 to create a drop down list of siamese, berman or moggy and NOT spaniel, doberman, retriever. Equally if I select "horse" in A1 then I want the drop down list in cell B1 to say racehorse, showjumper or pony and NOT spaniel, doberman, moggy etc. I have already created a list of dog, cat, horse in the spreadsheet and also lists for spaniel, doberman, retriever and then siamese, berman etc... Any advice gratefully received. Thank you in advance. Regards. Leisl Look here... http://www.contextures.com/xlDataVal02.html Ken Johnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function in drop down lists
You have answers at your first post.
Leisl wrote: Hi Please bear with me, I know what I want I just can't explain it! I have created a drop down list in cell A1 of dog, cat or horse. If A1 selects "dog" then I want cell B1 to create a further drop down list of spaniel, doberman, retriever BUT if I select "cat" in cell A1 then I want cell B1 to create a drop down list of siamese, berman or moggy and NOT spaniel, doberman, retriever. Equally if I select "horse" in A1 then I want the drop down list in cell B1 to say racehorse, showjumper or pony and NOT spaniel, doberman, moggy etc. I have already created a list of dog, cat, horse in the spreadsheet and also lists for spaniel, doberman, retriever and then siamese, berman etc... Any advice gratefully received. Thank you in advance. Regards. Leisl -- Dave Peterson |
| 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 | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
