Linking Validation Lists?

D

dosborne

Can you link drop down lists?

Example:

DropDown#1 has (A,B & C)
DropDown#2 has (1,2,3,4,5,6,7,8 & 9)

If Drop Down#1=A, Drop Down #2 = (1,2 & 3)
If Drop Down#1=B, Drop Down #2 = (4,5 & 6)
If Drop Down#1=C, Drop Down #2 = (7,8 &9)

Is this feasible?
Thanks,
Dan
 
R

Rodrigo Ferreira

Try something like this:

Example:
Col A COL B
1 A 1
2 A 2
3 A 3
4 B 4
5 B 5
6 B 6
7 C 7
8 C 8
9 C 9

Col C (Your List without dups)
A
B
C

Col G1
Validation List
=$C$1:$C$3

Col H1
Linked List
=OFFSET(A1;MATCH(G1;A1:A9;0)-1;1;COUNTIF(A1:A9;G1);1)
 
Top