Thanks a million, they all work well.
(How do you do that?)

"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.