Thread: 2 validation lists for the same value on another cell
View Single Post
  #3  
Old March 7th, 2009, 10:52 PM posted to microsoft.public.excel.worksheet.functions
[email protected][_2_]
external usenet poster
  
Posts: 30
Default 2 validation lists for the same value on another cell
On Mar 8, 12:26*am, "T. Valko" 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.