listbox B conditional of input in Listbox A

G

Guest

How do I set up listbox b choices to be a result of inpout from A? I have 9
school districts to list which will be the choice in A, Listbox B will be the
choice of only the schools in the district selected in A. I assume that it
is an IF stattement and a range set up but can someone help me to set this up?
 
J

JB

http://cjoint.com/?kFvtSwDs5J

1er list: =Choix1
2e list:

=OFFSET(Choix2;1;MACTH(A1;Choix1;0)-1;COUNTA(OFFSET(Choix2;;MATCH(A1;Choix1;0)-1))-1)

District1 District2 District3 District4
Scoll11 Scoll21 Scoll31 Scoll41
Scoll12 Scoll22 Scoll32 Scoll42
Scoll23 Scoll33

JB

Kim K a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox B if LIstbox A equals 3
Access Cannot select items in listbox 1
How to set excel pulldown list starting value to current cell valu 1
Form Filtering Help 8
Display only rows with data selected from a listbox 10
Listbox 2 takes the value of Listbox 1 3
How to bind filtered data in list box? 1
Add Listbox header using VBA 1

Top