VLOOKUP & IF or Sumproduct
Try this in A1:
=IF(OR(B1={"401n","401s","402n","402s"}),IF(C1="a" ,"CTA",IF(C1="c","STD","")),
IF(OR(B1={"501n","501s","502n","502s"}),IF(C1="a", "GIL",IF(C1="c","STA",""))))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Dale G" wrote in message
...
Correction to the last IF. the number text combo start with a 5.
My dilemma today is, how to have Cell A1 fill automatically with CTA, or
STD,
or GIL, or STA when the following conditions are true.
if Cell C1 is "a" & Cell B1 is "401n", or "401s", or "402n", or "402s"
then
Cell A1 will = CTA
if Cell C1 is "c" & Cell B1 is "401n", or "401s", or "402n", or "402s"
then
Cell A1 will = STD
if Cell C1 is "a"& Cell B1 is "501n", or "501s", or "502n", or "502s" then
Cell A1 will = GIL
if Cell C1 is "c" & Cell B1 is "501n", or "501s", or "502n", or "502s"
then
Cell A1 will = STA
The number text combination ("401n") is in column B before I receive the
file. I would like to enter the "a" or the "c" in column C and have the
proper data auto enter in Column A.
"Dale G" wrote:
My dilemma today is, how to have Cell A1 fill automatically with CTA, or
STD,
or GIL, or STA when the following conditions are true.
if Cell C1 is "a" & Cell B1 is "401n", or "401s", or "402n", or "402s"
then
Cell A1 will = CTA
if Cell C1 is "c" & Cell B1 is "401n", or "401s", or "402n", or "402s"
then
Cell A1 will = STD
if Cell C1 is "a"& Cell B1 is "501n", or "501s", or "502n", or "502s" then
Cell A1 will = GIL
if Cell C1 is "c" & Cell B1 is "401n", or "401s", or "402n", or "402s"
then
Cell A1 will = STA
The number text combination ("401n") is in column B before I receive the
file. I would like to enter the "a" or the "c" in column C and have the
proper data auto enter in Column A.
|