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
"changj3" wrote in message
...
| 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.