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?