Excel help?

gerturdeanna

Morning all.

You always manage to let me know what I need to do so I've come begging again!!

I'm creating a excel s/sheet at work and I want to bring back specific data in one column dependant on what has been selected in the column before.
For example, if white is selected(from a data validation list), I want the next column to only allow me to choose size 8,10,12 etc (again preferablly from a data validation).

Is this possible? Have I explained myself properly?

Thanks in advance

Gert x

rmg1

What you need is called cascading validation.
Google has a load of tutorials and tips/tricks to get you started.

It's easier to follow the tutorials rather than trying to explain on here.

gerturdeanna

Thank you - I knew there would be a way of doing it! I'll google under that reference.

Thanks

EchoLocation

I've always called it Dependant Validation. The premise being that you name your dependant lists - in this case the Sizes - using the precedent values - in this case the Colours.

Setup the following lists and name the ranges as per the headers

Colours
Red
White
Blue

Red
2
4
6

White
8
10
12

Blue
16
18
20

Setup the validation in the first column as normal using the named range 'Colours'. Then in the second column, instead of entering a named range you need to use the =INDIRECT function to select the value selected in the first column. Remember to ensure that the row reference is relative.

JABWootton

You could always ask on here
http://www.mrexcel.com/forum/index.php