help w/ data validation
 

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.

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.

Just to add to Jim's post...

Debra Dalgleish has some instructions at:
http://contextures.com/xlDataVal02.html

To show how to use one list dependent on a different cell.

changj3 wrote:

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.

--

Dave Peterson