Copying output in Excel

Hi, I have written a single cell formula in Excel which gives "Pension Amount" depending upon the inputs on "Age" and "Salary" of the pensioner from adjacent cells. Now I want to make a chart of pension amount depending upon age and salary as follows:
Age Salary PensionAmount
35 5000 .......
. . ...
. . ...
53 7500 .........

But copying and pasting the PensionAmount for each category of Age & Salary is proving a very tedious task. Each time I enter a different Age or Salary, the PensionAmount changes and I have to paste it manually in the above chart against the corresponding category.
Could u pls suggest any macro that will automatically "fill up" the "Pension Amount" in the corresponding categories for each Age and Salary.
I tried using "IF" statement as follows: =IF((AND(Age=A1,Salary=B1)),C1)
This fills up the correct PensionAmount for the relevant category of Age/Salary combination in the above chart. But when i run it for another combination of Age/Salary, the PensionAmount for the previous category becomes "False" or 0.
Pls help.
Regards
Vineet