Thanks for the response Roger. I have about 20 steps in the salary schedule
which gives a different annual raise based on the step. As a simple
illustration, moving from step 0 to step 1 gives the employee a $100 per year
raise. From step 1 to step 2 gives a $200 raise, step 2 to step 3 a $300
raise, etc. to step 20. With all employees set up in an Excel spreadsheet, I
am wanting my formula to read the step level of each employee and increase
the pay of each employee by the appropriate amount according to the
employee's step for the next year's budget prepartation. A lookup table
might be more appropriate but I have never used one and don't know where to
start.
> Hi
>
[quoted text clipped - 10 lines]
> > to
> > accomplish what I need?
Roger Govier - 16 Mar 2007 10:01 GMT
Hi
If your steps were exactly as you say throughout the range, then you
wouldn't need IF's or Vlookup's but I suspect they don't follow an
exactly linear increment from 1 to 20.
Set up a table in A1:B20
0 0
1 100
2 200
.
.
20 1200
Then with the step value in D1
=VLOOKUP(D1,$A$1:$B$20,2)
The table can be placed anywhere, even on another sheet and would be
better if it were a named range.
Insert>Name>Define> Name Salaries Refers to
=Sheet2!$A$1:$B$20
then
=VLOOKUP(D1,salaries,2)

Signature
Regards
Roger Govier
> Thanks for the response Roger. I have about 20 steps in the salary
> schedule
[quoted text clipped - 32 lines]
>> > to
>> > accomplish what I need?