if functions involving drop down lists.

[Guest]

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

 

[David Biddulph]

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.

 

[Peo Sjoblom]

There are description how to make a dependent validation here

http://www.contextures.com/xlDataVal02.html

Regards,

Peo Sjoblom

 

[Peo Sjoblom]

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