Data Validation (select from list) dependent on cell contents

[yorkshirelad]

Any help would be really appreciated on this one, I've spent hours attempting to make it work without success.

This is the scenario

In cell B1 is a drop-down where the user selects from a list =$E$1:$E$3 Dog, Cat, Cow
In cell B2 I need a drop-down where the list reflect what's chosen in B1

If it is a Dog (E1) the list is =$F$1:$F$3
If Cat (E2) the list is =$G$1:$G$2
If Cow (E3) = $H$1:$H$4

Many thanks for your assistance

 

[SydneyGeek]

There are a few ways to achieve this.
Here is a good tutorial page.

Denis

 

[yorkshirelad]

Many thanks that's what I needed!

 

[nicekev500]

Any help would be really appreciated on this one, I've spent hours attempting to make it work without success.

This is the scenario

In cell B1 is a drop-down where the user selects from a list =$E$1:$E$3 Dog, Cat, Cow
In cell B2 I need a drop-down where the list reflect what's chosen in B1

If it is a Dog (E1) the list is =$F$1:$F$3
If Cat (E2) the list is =$G$1:$G$2
If Cow (E3) = $H$1:$H$4

Many thanks for your assistance

First name all your ranges... Insert name, range.. don't include the heading just the elements. Label all your headings on row A dog, cat,cow. call this categories in name define. go to sheet 1 and go Validation, List, =category this will now show a drop down list with Dog, Cat, Cow.
Now to get the types of Dog, Cat, Cow. go a cell under and use: validation, List =indirect(substitute(A1," ","_")) ... substitute is used in case you want to use a heading like Wow cow.