help w/ data validation

C

changj3

is there a way to incorporate an if statement and a list? I want to use an
if statement which would allow me to list a group of choices based on what is
selected in a different cell. for example, if i choose "A" from a list in a
cell a1, it will pull only a list defined as "A" in cell a2.
 
J

Jim Rech

Lets say you have two lists named aList and bList. For the Source range in
the Data Validation dialog you could enter this formula:

=INDIRECT(A1&"List")

So an "a" in A1 returns the string "aList" which the INDIRECT function
converts to the named range.

--
Jim
| is there a way to incorporate an if statement and a list? I want to use
an
| if statement which would allow me to list a group of choices based on what
is
| selected in a different cell. for example, if i choose "A" from a list in
a
| cell a1, it will pull only a list defined as "A" in cell a2.
 
Top