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?