Seaching a Table

Good Day All,

I am fairly new to Access and am looking for some help. I have a table that I need to search to pull out data. The value needs to found based on salary and if it falls within a range and then all a percentage rate. I have attached some samples.

Would like to see the sql version if possible as that is what I am learning.

Its a calculation base on location. Its a benefit amount that is received based on the two factors.

1. Salary Range
2. The percentage is based on location.

The table is provided, not sure of a better way to display the table.

Yea, so the 50% is based on the location. I have a separate table that has the COLA already % by location and then the table referenced has it already linked to each individual. This is the percent that would be found in the column headings.

If I changed the headings, what would the lookup value be?

I'm excel I have it working. Two step process, but I assigned a number to where the salary falls, so each salary range has an assigned number. Then I did a separate vlookup/index to find the value.

So on the referenced table, it's a list of employees and their assigned COLA % based on where they are located. I'm trying to find a way to have that value be searched in the column headings and find the value to that individuals salary range, which are also column headings.

You basically summed it up already, but just writing it out for anyone else looking.