Get a specific date from a table based on a number

[emy1]

I have a table that looks like this:
1.ods (37.2 KB)

On my file, the list goes for the whole year, beginning from 1st December 2025 until 30th November 2026.
How can i get on which date was the minimum and maximum value for each column? I got the min and max, but I can’t get on which date happened, vlookup and hlookup don’t work.
Can you help me please? thank you.

[schiavinatto]

Hi @emy1, here’s an example, but if there are two dates with the same value, it returns the first one found.

1_GS.ods (26,4,KB)

[lodf2023]

Does xlookup replace index-match?

=XLOOKUP(B36,B$2:B$33,$A$2:$A$33)

=INDEX(A2:A33,MATCH(B36,B2:B33,0))