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.

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.


--
Biff
Microsoft Excel MVP


<(E-Mail Removed)> wrote in message
news:65485e7e-3ff8-470f-a004-(E-Mail Removed)...
> 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.

On Mar 8, 12:26*am, "T. Valko" <biffinp...@comcast.net> wrote:
> 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.
>
> --
> Biff
> Microsoft Excel MVP

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