Excel Programming - Formula Assistance

[James D. Sheehan]

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.

 

[CLR]

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

 

[Don Guillett]

We know who, salary amount, and step but we don't know "LANE"?

 

[James D. Sheehan]

I need to find the appropriate salary schedule lane. I know the salary
amount and the step placement...and I need to find the lane.

 

[James D. Sheehan]

We know the amount and we know the step placement...now we must find the lane
for this schedule amount so that the employee is placed correctly at either
the exact amount or the amount slightly greater.

 

[Don Guillett]

The question is:
What is the criteria to determine the lane?

 

[James D. Sheehan]

The criteria to determine the lane is... Given the step and the amount...go
across a schedule on the step until you find an amount = to or > than the
salary amount. Then just tell me what lane this is in the schedule. Is
there a way to post an excel file that portrays this problem?

 

[Don Guillett]

Send your file to my address below NOT to an attachment here.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

The criteria to determine the lane is... Given the step and the
amount...go
across a schedule on the step until you find an amount = to or > than the
salary amount. Then just tell me what lane this is in the schedule. Is
there a way to post an excel file that portrays this problem?