Ok, I have this problem with validation. Can I do the following or is there a
work around.

=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12),IF(E6="CMIN",$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12)

PG wrote:
Ok, I have this problem with validation. Can I do the following or is
there a work around.

=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12),IF(E6="CMIN",$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12)

You seem to have too many brackets there. Perhaps if you gave us a clue as
to what the intended outcome is to be?

In cell A1, there is a validation list of 5 items to choose from (ALB, CMIN,
Domestic etc.). When they choose one of the 5 items (let say ALB), cell E6
will give them a list of 3 items to choose, but if they choose CMIN, then it
will give them a list of 5 items to choose from. Is this possible?

"Paul Lautman" wrote:

PG wrote:
Ok, I have this problem with validation. Can I do the following or is
there a work around.

=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12),IF(E6="CMIN",$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12)

You seem to have too many brackets there. Perhaps if you gave us a clue as
to what the intended outcome is to be?

See Debra Dalgleish's site for instructions on "dependent lists".

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 13 Mar 2006 14:39:25 -0800, PG wrote:

In cell A1, there is a validation list of 5 items to choose from (ALB, CMIN,
Domestic etc.). When they choose one of the 5 items (let say ALB), cell E6
will give them a list of 3 items to choose, but if they choose CMIN, then it
will give them a list of 5 items to choose from. Is this possible?

"Paul Lautman" wrote:

PG wrote:
Ok, I have this problem with validation. Can I do the following or is
there a work around.

=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12),IF(E6="CMIN",$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6="ALB",$IQ$14,$IQ$4:$IQ$12)

You seem to have too many brackets there. Perhaps if you gave us a clue as
to what the intended outcome is to be?