I'm confused..........if you are given the salary, and the table contains
only salaries in steps, what information are you trying to retrieve?

Vaya con Dios,
Chuck, CABGx3



"James D. Sheehan" wrote:

I have a salary schedule that begins with $40,000 and has 40 steps down each
with in increase of $1,000 and 19 lanes wide each with an increase of $2,000.
So the schedule is ascending down and to the right. I am given a salary
amount and the step the individual should be placed on. I must find the
appropriate lane so that the individual would not lose salary.

I believe this must be done with a MATCH and HLOOKUP but I cannot figure it
out. Any help will be greatly appreciated. Thank you.
--
James D. Sheehan