Using Index Match for Salary Lookup based on Name Key, Position, Years of service

Hi Glenn;
I do like the INDEX MATCH, but I need to build the name key into it.
You are correct, it's not there in the LEAP because when I have tried to put the Name key in the LEAP, for some reason it doesn't work.
That is what I am trying to figure out.
How do I add the NAME KEY to the LEAP TABLE?
Thanks!!

The data in Contract Tab and Leap Schedule tab are not matching.
If the data is matching,it can be added

I have updated my spreadsheet to show what I have done that seems not to be working.
This is just a mock up of the original data.
The Contract tab for the salary works great UNTIL I add the NAME key to the Leap Table.
Does it matter that on the Leap Table when I add the name keys to column A that they span A3: to A165 while the salary table stops at row 38?

Right, because this is a "picture" based off of an enormous spreadsheet.
The years of service begins at 0 and actually goes through 35 years.
So, in my actual spreadsheet there is a 25 year value, but the forum does not support my actual data, so I could only go to 5 years.
The spreadsheet worked fine until I added column A to the Leap Schedule and now it doesn't work and I don't know why.
I thought I could just add a MATCH to my original formula to look up the Name key. In my original data, it won't work.

I guess name key will not be a criteria to calculate the salary.
In that case you can get away with a simple INDEX-MATCH formula.

See attached file

Thank you! I think that I built it as far as I could with the simple index formula that I had prior.
I think that I was trying to figure out how simplify it even more and I can't do that.
Thank you for your help!

I think restructuring the source as database model will make your work easier..

Find attached file and the data model..

In this structure, the data can be obtained using a simple database function DGET