Data Triggers

I'm relatively new to spreadsheets and excel.

I'm working with a spreadsheet for mileage allocation. The mileage is funded from a single source but allocated to several people.

In the spreadsheet, is it possible for the alpha entry in, for instance, column "C" cause the data in column "B" to populate in columns "D", "E". or "F" depending on the entry in column "C"?

Example. Can the mileage cash value that's populated in column "B" get sent to a cell in either columns "D", "E", or "F" according to the name inserted in column "C"   

Entry "John" would cause B to populate D;

"Dave" would cause B to populate E and

"Jane would cause B to populate F

so I can tally each person's share of the mileage without having to re-enter that amount in each of the columns?

Any help in this would be appreciated.