Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop Down List
is it possible to have different dropdown lists appear
depending on value in cell to the left of where you have your dropdown list. e.g if A1 = "LP" then b1="Dropdownlist1" if A1 = MP then b1="Dropdownlist2" etc etc Hope you can help Pete |
#2
|
|||
|
|||
There are instructions for dependent data validation lists he
http://www.contextures.com/xlDataVal02.html Pete wrote: is it possible to have different dropdown lists appear depending on value in cell to the left of where you have your dropdown list. e.g if A1 = "LP" then b1="Dropdownlist1" if A1 = MP then b1="Dropdownlist2" etc etc Hope you can help Pete -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi
Into data validation list's source enter the formula =IF($A1="LP",Dropdownlist1,IF($A1="MP",Dropdownlis t2,"")) where Dropdownlist1 and Dropdownlist2 are named ranges. Or, when you have to cope with many sublists, then maybe you arrange them as matrix on separate sheet (p.e. Lists), like LP MP .... lp1 mp1 .... lp2 mp2 .... .... ... ... Now define the named range for data validation lists source as dynamic named range, like (on fly, so you have to test it yourself, but I hope you get the idea) YourList=OFFSET(Lists!$A$2,0,MATCH($A1,Lists!$A$1: $Z$1,0)-1,COUNTIF(OFFSET(L ists!$A2,0,MATCH($A1,Lists!$A$1:$Z$1,0)-1,100,1),"<")-1,1) Or, when all sublists are always of same length, you can use INDEX function to get a single column from matrix (instead of OFFSET) Arvi Laanemets "Pete" wrote in message ... is it possible to have different dropdown lists appear depending on value in cell to the left of where you have your dropdown list. e.g if A1 = "LP" then b1="Dropdownlist1" if A1 = MP then b1="Dropdownlist2" etc etc Hope you can help Pete |
#4
|
|||
|
|||
Brilliant Debra, Exactly what I want thanks.
-----Original Message----- There are instructions for dependent data validation lists he http://www.contextures.com/xlDataVal02.html Pete wrote: is it possible to have different dropdown lists appear depending on value in cell to the left of where you have your dropdown list. e.g if A1 = "LP" then b1="Dropdownlist1" if A1 = MP then b1="Dropdownlist2" etc etc Hope you can help Pete -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
edit a drop down list | Excel Discussion (Misc queries) | |||
Drop dow list complication | Excel Discussion (Misc queries) | |||
autocomplete from a drop down list | Excel Discussion (Misc queries) | |||
Drop down list | Excel Discussion (Misc queries) |