Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation and drop down lists | Excel Discussion (Misc queries) | |||
data validation lists and invoices | Excel Discussion (Misc queries) | |||
data validation - select multiple options? | Excel Discussion (Misc queries) | |||
multiple validation in a single cell | Excel Discussion (Misc queries) | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions |