Thanks Pete_UK for the info. Everything is working great !

"Barb @ Work" wrote:

I have a spreadsheet with 3 columns, each representing a different "code". I
want to write a formula that will evaluate each of the 3 code columns for
each row and, based on the results, assign an English translation to each
code, and stack those translations on top of each other in on cell in a
different column for that row. Each code column will have a max of 3
different code values.

Example:
Column A = Status
Value of "O" = Status is Open
Value of "C" = Status is Closed
Value of "P" = Status is Pending

Column B = Billing Flag
Value of "M" = Monthly Billing
Value of "W" = Weekly Billing
Value of "T" = Transaction Billing

Column C = Customer Type
Value of "C" = Corporate Customer
Value of "P" = Personal Customer
Value of "T" = Tax-Exempt Customer

For row 1, if the value in columns A, B, & C respectively are P, T, P then
column D for row 1, which is where the English translation results are to go,
will be:

Status is Pending
Transaction Billing
Tax-Exempt Customer

Any ideas?