Return value from table based on date and amount

[Aubrey Reel]

How do I return the Position from Table 2 to Column H in Table 1 using the below criteria:

date_week_ended year from Table 1 match to the corresponding column in Table 2
AND
Hourly Rate from Table 1 that is within the range of pay listed in Table 2 (e.g. for Year 2016 Tech 1 range = $11-13.99, Tech 2 range = $14-17.99, etc)

For example:
date_week_ended = 3/31/2016
Hourly Rate = $13.50
Position = Tech 1

Any help appreciated - I am running myself in circles on this one!

 

[Aubrey Reel]

It worked!! Thank you, thank you, thank you!

 

[awoohaw]

Okay, but I'm not sure about the final 2 rows as they are 2016 and over $14, they should be Tech 2 from what I see.
Can you post the calculation (Formula) you have in cell H9?

If it is working, I'm happy you found a solution.
and welcome to the Mr. Excel forum!

 

[Aubrey Reel]

Oh no, I was adjusting the rates. It works! Sorry about that. Here are a couple of better screen shots.

Then if I adjust the 2016 Tech 2 starting rate to $14. Beautiful!

 

[awoohaw]

yes, wonderful! I'm pleased you found a solution.

And welcome to the Mr. Excel Forum.
Best wishes!