I have a list of baseball players and their salaries. The salaries are not listed per calendar year, but rather per season of the contract, ie, the current year would be "year0", next year would be "year1", etc...

I'm trying to get index/match to find a "Player A, Year 0" and then return the data in the column to the immediate left, to give me "Year 1"

The problem is, the contract that is being located is located anyone in a range from "players_contract!L8:S1022"

So far, I can find the year that the player's contract starts, the find the correct year 0 salary, but don't know how to turn that into year 1, year 2, etc...

Attached is the data. The number that should be located in the cell has been entered in RED.

Thanks!
salaries.xlsx