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