leaderboard in calc using =(H)LOOKUP() [closed]

edit

Found the answer already:

=HLOOKUP(LARGE(AA70:AD70;1);AA70:AD71;1;0)

does the trick as long as the names are directly beneath the score.

Is there any way to get the names from anywhere in stead of directly beneath the row with scores?

---------------------------------------EDIT---------------------------------------

I found out that with the third parameter you can select of which row in the range selected in the second parameter you want to take the output.

So in my case, I put the names of the persons on row 81 and their scores on the rows 63 to 80. Then I used HLOOKUP to find out which value on the same row was the highest with =LARGE(AA70:AD70;1) and used this value to find the right column on the first row of the area selected in the second parameter. In my case, this was the range AA70:AD81, and the first row in that area is AA70:AD70. Once the column has been found, it will look in the row selected by the third parameter in the area selected by the second parameter. In my case, this area was AA70:AD82, and it selected the row was 12, so it took the item on row 81 in the same column as the number selected by the =Large() command. The fourth parameter was just to tell the command that the numbers were not sorted.

Final command (in my case): =HLOOKUP(LARGE(AA70:AD70;1);AA70:AD81;12;0)

(BTW: can someone accept this answer? Cause I can't accept my own answers because my karma is to low :( )