software

I am trying to build a formula that will fill a cell with the value from a
table if certain conditions exist in another adjacent cell. I tried to use
the IF formula and it would work except I need a total of 4 conditions.
In other words I want to fill a cell with one value if the adjacent cell
contains CCE and a different reference if the cell contains BCP etc.
Thanks for your help.
--
TV

Maybe something like........

=IF(A1=quot;CCEquot;,quot;ReturnThisquot;,IF(A1=quot;BCPquot;,quot;ReturnThatquot; ,IF(A1=quot;ONEquot;,quot;ReturnThirdValuequot;,IF(A1=quot;TWOquot;,quot;Retur nFourthValuequot;,quot;quot;))))

Vaya con Dios,
Chuck, CABGx3

quot;TVquot; wrote:

gt; I am trying to build a formula that will fill a cell with the value from a
gt; table if certain conditions exist in another adjacent cell. I tried to use
gt; the IF formula and it would work except I need a total of 4 conditions.
gt; In other words I want to fill a cell with one value if the adjacent cell
gt; contains CCE and a different reference if the cell contains BCP etc.
gt; Thanks for your help.
gt; --
gt; TV

Thanks, it worked. I knew the answer was out there somewhere.
--
TVquot;CLRquot; wrote:

gt; Maybe something like........
gt;
gt; =IF(A1=quot;CCEquot;,quot;ReturnThisquot;,IF(A1=quot;BCPquot;,quot;ReturnThatquot; ,IF(A1=quot;ONEquot;,quot;ReturnThirdValuequot;,IF(A1=quot;TWOquot;,quot;Retur nFourthValuequot;,quot;quot;))))
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;TVquot; wrote:
gt;
gt; gt; I am trying to build a formula that will fill a cell with the value from a
gt; gt; table if certain conditions exist in another adjacent cell. I tried to use
gt; gt; the IF formula and it would work except I need a total of 4 conditions.
gt; gt; In other words I want to fill a cell with one value if the adjacent cell
gt; gt; contains CCE and a different reference if the cell contains BCP etc.
gt; gt; Thanks for your help.
gt; gt; --
gt; gt; TV

Happy to help.........and thanks for the feedback....

Vaya con Dios,
Chuck, CABGx3
quot;TVquot; wrote:

gt; Thanks, it worked. I knew the answer was out there somewhere.
gt; --
gt; TV
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Maybe something like........
gt; gt;
gt; gt; =IF(A1=quot;CCEquot;,quot;ReturnThisquot;,IF(A1=quot;BCPquot;,quot;ReturnThatquot; ,IF(A1=quot;ONEquot;,quot;ReturnThirdValuequot;,IF(A1=quot;TWOquot;,quot;Retur nFourthValuequot;,quot;quot;))))
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;TVquot; wrote:
gt; gt;
gt; gt; gt; I am trying to build a formula that will fill a cell with the value from a
gt; gt; gt; table if certain conditions exist in another adjacent cell. I tried to use
gt; gt; gt; the IF formula and it would work except I need a total of 4 conditions.
gt; gt; gt; In other words I want to fill a cell with one value if the adjacent cell
gt; gt; gt; contains CCE and a different reference if the cell contains BCP etc.
gt; gt; gt; Thanks for your help.
gt; gt; gt; --
gt; gt; gt; TV