2 validation lists for the same value on another cell

[rumkus]

Hi

Column A = Top
Column B validations list = Top list 1
Column C validations list = Top list 2
or
Column A = Bottom
Column B validations list = Bottom list 1
Column C validations list = Bottom list 2

Is this possible without vba ? Thanks in advance.

 

[T. Valko]

Assuming you have 4 lists named:

Top1
Top2
Bottom1
Bottom2

As the source for B1:

=INDIRECT(A1&1)

As the source for C1:

=INDIRECT(A1&2)

Note that if the lists are dynamic ranges defined using functions like
OFFSET this won't work.

 

[rumkus]

Assuming you have 4 lists named:

Top1
Top2
Bottom1
Bottom2

As the source for B1:

=INDIRECT(A1&1)

As the source for C1:

=INDIRECT(A1&2)

Note that if the lists are dynamic ranges defined using functions like
OFFSET this won't work.

Will change all dynamic ranges surely.
Thanks a lot T.