Returning a specific value based on one value in a range of cells.

Hello!

I am looking at two tables, and I need to return a "salary" (hourly wage) value based on an employee "step" that advances every year. In Table 2 below, in the orange fields, I'm looking to return the proper value, for each person, for the step they advance each year.

So, for example, in Status Quo Wages, in 2018 Abigail Brainard should be making $10.34, an Apple Picker's Step 3 Status Quo Salary.

I need to say, "Based on that year's Column F step in Table 2, xyz person will make the wages in Columns D through O." I've tried a bunch of nested IF functions but haven't quite got there.

I've attached a version of my table for reference.

Thanks!

Steven