Is it possible to get a reference to a calculated cell?

Question

excel

The essence of the problem. There is a table with columns: Name and scores. I calculate the leader in points through the MAX in the range. Can I get the member name based on this found MAX? Conventionally, the leader is located in line 3. In D3 lies his score, which is the maximum, you need to get the NAME, which lies in C3. Thanks in advance!

Answer 1

in English, google for "excel find row number of maximum value"
https://exceljet.net/formula/position-of-max-value...
or in Russian, google for "excel find row number of maximum value" (yes , you can do better, but it will do)
https://office-guru.ru/excel/poisk-maksimalnogo-zn...
https://excel2.ru/articles/adres-yacheyki-v-ms-exc.. .Google
is your friend.

Answer 2

INDIRECT (it is, God forgive me, INDIRECT)

Answer 3

Finding the maximum and filtering the names by it:
=FILTER(C:C;D:D=макс(D:D))
If only the first one is needed, then use ARRAYCONSTRAIN()