Excel 2007 : Help populating cells according to combinations

[jenna@telstrashop]

Hello,

I am trying to find out whether it is possible to get a certain result from the combined values of a number of other cells that have drop downs. Obviously you can only pick certain amounts from the drop downs, but different combinations would come up with differen results. Eg:

Options for Column A: 12/24 Months
Options for Column B: 5/10/29/39/59 Data pack
Options for Column C: New/Upgrade

Column D: Should automatically reflect the amount of points according to the combination of above options

Column A Column B Column C Column D
12 29 New 20 points
24 10 Upgrade 15 points


Does anyone know if this is possible?

Would greatly appreciate any help.

Kind Regards,
Jenna