Assuming MAX function is operating on a single column with fixed
number of rows you can use the following steps

Cell 1 formula =MATCH(MAX(Sheet2!A1:A11),Sheet2!A1:A11)
Cell 2 formula =ADDRESS(B1-2,1,,,"Sheet2")
Cell 3 formula =INDIRECT(B2)

HTH

Regards
Anirudh