Distributing Column Data Across A Worksheet

I have a sheet with 5 columns in use at the moment.
Col: A - E . Col C has a Score and Col D has Game #

I'll like some code to look at each cell in col D and based on the Game# copy the value from the corresponding Col C to the Game column that is set up for that Game. ( I can set these up manually )

Col D can contain both numbers or text

Something like

IF D2 = 23, C2 = H2
IF D2 = 29, C2 = M2
IF D2 = "HOME", C2 = W2

etc etc

Col D can contain up to 20 possible numeric values & 8 possible text values

Also: Since I know all the 28 possible values that Col D can contain, how can I also get those columns set up automatically using VBA and SUM those columns that are set up with the numeric values at the last row.