I am trying to get a formula for my chart and am having no luck - with all
the formulas I enter (using IF, SUM, etc) nothing seems to work out.

So if someone could please tell me how to acheive my results I would greatly
appreciate it (please include which formula I should select (ie: IF, SUM)

I have 2 columns - one column I want to be able to put a year value (ie: 1,
2, 3) and in the next column I want it to automatically put the appropriate
number for the year I entered.
Example:
1 = 20
2 = 30
3 = 40

Any help with this would be greatly appreciated.

Thank you