Date of the lowest value

[ButterMan]

I have a table where there are dates and values. I’m trying to get the lowest value’s date, but it won’t work.

So, how do I get the date of the lowest value?

[mikekaganski]

@ButterMan

it won’t work

There is an error in “it”; it would be hard to point to the specific place without “it” presented for discussion (best as an ODS with sample data, wanted result, and attempted formulas).

[Villeroy]

=INDEX(dates;MATCH(MIN(values);values;0))

[suokunlong]

Assume you have values in colume A, dates in colume B. First, use MIN function to get the minimum value in column A, then use VLOOKUP function to lookup the date for this minimum value in column A:B:

=VLOOKUP( MIN(A:A), A:B, 2, 0)