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

Multiple Validation Lists
 

You can create dependent data validation lists. There are instructions
he

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

Multiple Validation Lists
 

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
he

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