software

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

=IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12),IF(E6=quot;CMINquot;,$IQ $14,$IQ$4:$IQ$12))

It would seem to work but it doesn't. The first part works fin.
=IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12)PG wrote:
gt; Ok, I have this problem with validation. Can I do the following or is
gt; there a work around.
gt;
gt; =IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12),IF(E6=quot;CMINquot;,$IQ $14,$IQ$4:$IQ$12))
gt;
gt; It would seem to work but it doesn't. The first part works fin.
gt; =IF(E6=quot;ALBquot;,$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?

quot;Paul Lautmanquot; wrote:

gt; PG wrote:
gt; gt; Ok, I have this problem with validation. Can I do the following or is
gt; gt; there a work around.
gt; gt;
gt; gt; =IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12),IF(E6=quot;CMINquot;,$IQ $14,$IQ$4:$IQ$12))
gt; gt;
gt; gt; It would seem to work but it doesn't. The first part works fin.
gt; gt; =IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12)
gt;
gt; You seem to have too many brackets there. Perhaps if you gave us a clue as
gt; to what the intended outcome is to be?
gt;
gt;
gt;

See Debra Dalgleish's site for instructions on quot;dependent listsquot;.

www.contextures.on.ca/xlDataVal02.htmlGord Dibben MS Excel MVP

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

gt;In cell A1, there is a validation list of 5 items to choose from (ALB, CMIN,
gt;Domestic etc.). When they choose one of the 5 items (let say ALB), cell E6
gt;will give them a list of 3 items to choose, but if they choose CMIN, then it
gt;will give them a list of 5 items to choose from. Is this possible?
gt;
gt;quot;Paul Lautmanquot; wrote:
gt;
gt;gt; PG wrote:
gt;gt; gt; Ok, I have this problem with validation. Can I do the following or is
gt;gt; gt; there a work around.
gt;gt; gt;
gt;gt; gt; =IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12),IF(E6=quot;CMINquot;,$IQ $14,$IQ$4:$IQ$12))
gt;gt; gt;
gt;gt; gt; It would seem to work but it doesn't. The first part works fin.
gt;gt; gt; =IF(E6=quot;ALBquot;,$IQ$14,$IQ$4:$IQ$12)
gt;gt;
gt;gt; You seem to have too many brackets there. Perhaps if you gave us a clue as
gt;gt; to what the intended outcome is to be?
gt;gt;
gt;gt;
gt;gt;