You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Colin" wrote in message
...
Thanks Bill that worked :) Note that this relies on the columns being
sorted
by A then B but thats fine for me.

"T. Valko" wrote:

Try this...

Assume your first drop down is in cell D1.

As the sorce for the dependent drop down use:

=OFFSET(B1,MATCH(D1,A:A,0)-1,,COUNTIF(A:A,D1))

--
Biff
Microsoft Excel MVP


"Colin" wrote in message
...
Hi

I want to be able to have two drop down lists using the data below. If
I
select Dog, the second list must present me with Meat and Bones. If I
select
Cat, the second list must present me with Meat.

I cannot use named ranged by splitting the columns into Dog Food, Cat
Food,
Cow Food etc... They must be in this two-column associated structure.

A B
Dog Meat
Dog Bones
Cat Meat
Cow Grass

Thanks,
Colin