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

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

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

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