Results 1 to 2 of 2
Thread: Looking up range values (2K-SR1)
2004-02-13, 16:46 #1
- Join Date
- Aug 2001
- Bloomington, Indiana, USA
- 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>
2004-02-13, 16:59 #2
- Join Date
- Jan 2001
- 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.