I have a table of years and hourly wages in a worksheet:

2012 $10.00
2013 $11.00
2014 $12.00
2015 $13.00

In another worksheet, I want to get the average wage based on a lookup of a starting year and ending year. I've tried a variety of functions using lookup, vlookup, indirect, etc, but can't get it to work.

Please advise.

Thanks