oops you wanted to go to the right
=OFFSET(J5,MATCH(MAX(J5:J28,0),J5:J28,0)-1,-1)
or
=INDEX(I5:I28,MATCH(MAX(J5:J28,0),J5:J28,0))

"bj" wrote:

I would recommend using
=OFFSET(J5,MATCH(MAX(J5:J28,0),J5:J28,0)-1,1)
or
=INDEX(K5:K28,MATCH(MAX(J5:J28,0),J5:J28,0))

While it is not needed specifically in this case, I would use the ,0 in a
match whenever I do not definately know if the data is in ascending order.

Is there any concern that there might be several cells with the max value?

"Bob Phillips" wrote:

=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