Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help needed with lookup formula (2003)

    I have a spreadsheet of employee evaluation scores. These scores are associated with wage increases. I know this would be very simple using a vlookup if there was one standard scale, but we have 9 different scales that can be used, depending on what job the employee has. The data I collect has the job number and the evaluation score. I need to convert this to the amount of wage increase for that particular job/score combination. I have separate tabs that contain the table of jobs and what scale they correspond to, and the scales themselves. I have formulas that I have been using that give me fairly accurate results by using percentages, but have found an error in the percentages applied to the scales that is giving a false result. There are also jobs listed that are exempt from an increase but receive evaluation scores and I need to take those jobs into consideration as well. The biggest problem is that the percentages vary between the scales.



    What formula could I use to give me the result I am looking for? I have attached a sample of the spreadsheet for review.

    Thanks in advance,
    Attached Files Attached Files
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help needed with lookup formula (2003)

    I don't have the slightest idea what your workbook does.
    Could you provide a detailed explanation, with some clear examples, of how the wage increase should be calculated?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Help needed with lookup formula (2003)

    Does this do what you want (I changed the order in "Scale" to be increasing to get thh formula to work: Below, meets, Exceeds...)

    Steve
    Attached Files Attached Files

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help needed with lookup formula (2003)

    Steve,

    This worked perfectly. Thank you!!
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •