How to flag column values

[#1]

Hi Friends,

I have a data set like this

A B C Code Amount

1 2 3  PC 900

1 3 4  PM  800

1 2 4   TM 800

1 2 6  PC 800

1 3 4 PM 800

Now I have decide the Amount column as sales amount, Insurance amount  and Commisions Amount based on the combinations of A B C and PC.

For example if A =1 B=2 C=3 and Code =PC then the Amount should be flagged as Sales amount.

                   if A=1 B=3  C=4 and Code=PM then the Amount should be flageed as Insurance amount.

[#2]

The answer was correct.

But Apply Map gave me easiest way to solve my problem.

Thanks for your answer