Thread: Multiple Validation Lists

Hi,
I'm trying to create an order form and want to use a validation list in A1
with ACCESSORY selections PROP, INSTRUMENT, HARNESS etc and based upon that
selection, I want another list in B1 which gives options available for PROP,
i.e.
PROP (choices in next list -> size B1, B2, B3 etc)
INSTRUMENT (choices -> tachometer, voltmeter, etc)
HARNESS (choices -> 3m, 6m, etc)
I will then use a vlookup formula in C1 to return the part # from
ACCESSORIES array, and A1:C1 would be copied to A1:C20 so that up to 20
accessories could be selected. Results in C1:C20 would then feed into an
order form.
I just don't know how to create multiple validation lists for the same cell
(B1), dependent upon what is selected in A1.....
Should I be using something else (INDEX)?
Thanks!
Alison

You can create dependent data validation lists. There are instructions
here:

http://www.contextures.com/xlDataVal02.html


Alison wrote:
> Hi,
> I'm trying to create an order form and want to use a validation list in A1
> with ACCESSORY selections PROP, INSTRUMENT, HARNESS etc and based upon that
> selection, I want another list in B1 which gives options available for PROP,
> i.e.
> PROP (choices in next list -> size B1, B2, B3 etc)
> INSTRUMENT (choices -> tachometer, voltmeter, etc)
> HARNESS (choices -> 3m, 6m, etc)
> I will then use a vlookup formula in C1 to return the part # from
> ACCESSORIES array, and A1:C1 would be copied to A1:C20 so that up to 20
> accessories could be selected. Results in C1:C20 would then feed into an
> order form.
> I just don't know how to create multiple validation lists for the same cell
> (B1), dependent upon what is selected in A1.....
> Should I be using something else (INDEX)?
> Thanks!
> Alison


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you so much -- that was exactly what I was looking for!!
Alison

"Debra Dalgleish" wrote:

> You can create dependent data validation lists. There are instructions
> here:
>
> http://www.contextures.com/xlDataVal02.html
>
>
> Alison wrote:
> > Hi,
> > I'm trying to create an order form and want to use a validation list in A1
> > with ACCESSORY selections PROP, INSTRUMENT, HARNESS etc and based upon that
> > selection, I want another list in B1 which gives options available for PROP,
> > i.e.
> > PROP (choices in next list -> size B1, B2, B3 etc)
> > INSTRUMENT (choices -> tachometer, voltmeter, etc)
> > HARNESS (choices -> 3m, 6m, etc)
> > I will then use a vlookup formula in C1 to return the part # from
> > ACCESSORIES array, and A1:C1 would be copied to A1:C20 so that up to 20
> > accessories could be selected. Results in C1:C20 would then feed into an
> > order form.
> > I just don't know how to create multiple validation lists for the same cell
> > (B1), dependent upon what is selected in A1.....
> > Should I be using something else (INDEX)?
> > Thanks!
> > Alison
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>