Re: Excel Programming - Formula Assistance

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"James D. Sheehan" <jim@displayname@discussions.microsoft.com> wrote in message news:36719621-9D9A-4FC5-AEA9-1AF78E44ECF6@xxxxxxxxxxxxxxxx
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

.

Loading