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