Two Dimensional Lookup

Hi

I am using Excel 2003. In my attached workbook I have two worksheets titled “Parameter” which are Basic Salary (numbers vertically under each grades) and “Grade” (M-1 to S-6 horizontally).

In other worksheet “Calculation” I have staff database. My formula should look at “Propose Number of Increment” in column E, locate the present basic salary under Present grade in worksheet “Parameter” and pickup proposed basic based on the number of increments.

In column F, I have given expected result “Proposed Basic SHOUL BE”.

I have been trying to built up of formula in column G which may please be ignored.


Swastik