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

    Looking up range values (2K-SR1)

    I am attempting to create a list of salary ranges for a membership program at a fitness facility. The fees are based on salary. I do not want my staff to look up the actual salary, so I have downloaded the salary information to an excel spreadsheet, and would like to convert it to a range that matches the ranges for the memberships.

    I have attached a sample worksheet that has 'dummy' data one one tab, and the ranges on another. I would like to keep the tabs separate because the data will be refreshed on a daily basis from a data warehouse. I have looked at the lookup formulas, and cannot seem to make these work for this problem.

    Thanks in advance for any assistance received.
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking up range values (2K-SR1)

    See the attached file. I have changed the Range sheet so that you can use VLOOKUP to get the required result.

Posting Permissions

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