yogi_Compute Rate Of Pay Based On Position and Years

Google Spreadsheet   Post  #2152

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-13-2017

question by drdfoley:

https://productforums.google.com/forum/#!topic/docs/WPX4pFCL12E;context-place=forum/docs
Lookup value based on two criteria

I want to figure out the rate of pay for an employee based on the position and the number of years worked.  The first sheet has the employee's position and the number of years worked. The second sheet has a list of positions and the rate of pay based on the number of years worked.

I have tried a variety of formulas with no luck.  I am able to do the lookup based on the position but don't know how to get the rate of pay based on the number of years worked. Any help would be appreciated.

Thank you,

Dianna

Here is the sheet:

https://docs.google.com/spreadsheets/d/1o6l3zVG--trtg7j7LyWxczqc8r8lZVf6Op8JJ6Mtipo/edit?usp=sharing