Multiple Validation Lists

[Guest]

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]

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

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

 

[Guest]

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