One way

=IF(OR(A1={"ADJ";"TUI";"STE"}),"A",IF(OR(A1={"REFU ND";"BKS"}),"E",""))

assuming they start in A1, copy down as long as needed

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Jess" wrote in message
...
I have a large worksheet and hate to use the fill down for this.

Here's my scenario:

In column A there are different values. Examples: ADJ, REFUND, TUI, STE,
BKS, etc.
In column B, I need there to be an A or an E depending on which value is
in
column A. So, if ADJ, TUI or STE are in column A, an A would go in column
B.
If the value in Column A is REFUND or BKS, then E would go in Column B.

Any suggestions on how to make this work?

Thanks!
--
Jess