Excel Programming - Formula Assistance
 

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

Excel Programming - Formula Assistance
 

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

Excel Programming - Formula Assistance
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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

Excel Programming - Formula Assistance
 

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


"CLR" wrote:

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

Excel Programming - Formula Assistance
 

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.
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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

Excel Programming - Formula Assistance
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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.
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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

Excel Programming - Formula Assistance
 

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?
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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.
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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

Excel Programming - Formula Assistance
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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?
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote in
message ...
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.
--
James D. Sheehan


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James D. Sheehan" wrote
in
message ...
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