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

Bob:

My Q does not have to do with the LAST "-1" << which is the Column
argument (I understand that one;

My Q has to do with the "-1" at the end of the Row argument, that is ...
J5:J28,0)-1, <<<
WHY - See more extensive results below (in my orig write-in)..

Tks,

Jim




"Bob Phillips" wrote in message
...
Jim,

It applies to the OFFSET column, not to the MATCH.

Mangesh is looking left for the offset value. I (wrongly) looked right, so
I
used 1 (+1).

--
HTH

Bob Phillips

"Jim May" wrote in message
news:Yf_ke.18456$Fv.10788@lakeread01...
Why the "-1" in the row argument?
When I from the formula bar highlite the
MATCH(MAX(J5:J28),J5:J28,0) only and F9
it return the correct position WITHOUT the need for the -1. (*&%$^%$???
TIA,
Jim May

"mangesh_yadav"

wrote in message
news:mangesh_yadav.1pl7cy_1117023660.9539@excelfor um-nospam.com...

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

Mangesh


--
mangesh_yadav

------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=373856