OK, found OUT something (I didn't fully understand - and still don't
totally, but) If you commit TS's Original formula with the
Ctrl+Shift+Enter keys VERSUS just eh enter key - It works WHEREEVER it
is entered or later moved Or copied. The "CSE" conerts the normal
formula into what is called
An array-formula - which is what is needed, Hope this helps,,,
Jim

"JMay" wrote in message
:

I see what you mean and I too don't understand why the last parameter
(the A:A) gets messed up evaluating to #NUM! - Using my offset function
(modified
Below changing the A1 ref to $A$1) it seems to work wherever it's moved.

=OFFSET($A$1,MATCH(MAX(B:B),B:B,0)-1,0)

I'm interested in know why the #NUM! occurs...

Jim May

"Eric" wrote in message
:

Thank everyone for suggestion

=INDEX(MATCH(MAX(B:B),B:B,0),A:A)
If I input this formula in cell C1, then it works fine, but if I input this
formula in cell C2, then it returns #REF!, could you please tell me how to
fix this value?
Thank everyone very much
Eric