Paul,

Thanks for your example! I finally see how it works now! And thanks
everyone who put in to help.

"Paul Lautman" wrote:

> Take a look at http://www.sunnyacres.co.uk/validationlists.xls
>
> Michael wrote:
> > Is there a way to get 2 different INDIRECT data validation lists from
> > one main validation?
> >
> > ie. cell A1 has a data validation list of silver,gold,red,blue.
> >
> > If cell A1 is "silver", I want an INDIRECT data validation list with
> > 1,2,3,4,5 in cell B1
> >
> > If cell A1 is "silver", I want an INDIRECT data validation with
> > Mats,Owen,Joe,Alex,Ed in C1.
> >
> > Thanks,
> >
> > Joe
>
>
>
>