Hi!

Try this:

A1:A31 = series from 0 to 30

B1:B31 = salaries in ascending order

C1 = $73,415.13

=INDEX(A1:A31,MATCH(C1,B1:B31))

Biff

"Cybertech" wrote
in message ...

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