Linking cell to 2 columns

[Yepp12]

I have this excel file (see attached) that I want to make a change to. In the file, I would like to be able to change the ranges in column F or the salary in column G and have the salaries in column C change. For example, john smith has 61 apps and makes 30000. If I were to change the apps range in column F from 60-64 to 62-66 or the salary in column G from 30000 to 38000, how can I get John's salary change automatically?

[Special-K]

This is not complete but will go someway to what you are trying to achieve.

In E2 and going down enter the first lowest number of the apps, e.g. 60, 65, 75,85,95,105
In C2 enter

=VLOOKUP(B2,E2:G7,3)

and copy the formula down the column

As you change a value in column B the salary will change accordingly