Here's one way...

Assume this is your data:

...........A..........B
1........A.........22
2........B.........17
3........C.........44
4........D.........12
5........E..........15

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0)-1)

This will work correctly *unless* the max value in B1:B5 is located in B1.
So, what result do want if that is the case?

--
Biff
Microsoft Excel MVP


"Stan" wrote in message
...
I have found a value using the MAX formula and would now like to return the
value found in the cell one row above and one column before the original
position of this result. Is this possible?