=OFFSET(J5,MATCH(MAX(J5:J28),J5:J28,0)-1,1)

or

=INDEX(K5:K28,MATCH(MAX(J5:J28),J5:J28,0))

--
HTH

Bob Phillips

"Voodoodan" wrote in
message ...

Hi,

I've got a range of numbers, J5:J28. I can get the maximum value
using:

=max(j5:j28)

However, I want to find that max number and find the offset value 1
column to the left.

Is this possible within a formula?

I've tried all sorts of combos with MAX and OFFSET but can't get this
one.

Any help would be appreciated.

Thanks,
Dan.


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile:
http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=373856