Hi,

I’m trying to make some modifications to a salary matrix and
I’m having trouble with a lookup.

In column A I have a series of numbers from 0 to 30 representing pay
grade steps where 0 represents a new employee and 30 represents an
employee having completed 30 years of service. In column B I have an
annual salary for each of the corresponding pay grade steps.

I want to take a new salary and find the closest salary in column B and
return the corresponding step number.

For example if the new salary is $73,415.13 and the matrix shows step
15 is 73,205 and step 16 is 73,665, I want to return a 15.

How could I accomplish this?

Thanks!


--
Cybertech
------------------------------------------------------------------------
Cybertech's Profile: http://www.excelforum.com/member.php...o&userid=26533
View this thread: http://www.excelforum.com/showthread...hreadid=500526