Formula that can automatically classify monthly expenses

Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as I am input the data. Thanks
E.g.

Date Name classification amount travels training logistic
1/1/16 X travels 200 ?
4/1/16 H training 500 ?
6/1/16 G logistic 500 ?
15/1/16 K travels 600 ?
23/1/16 O training 900 ?
30/1/16 S logistic 300 ?