I have temperature data for many years and am trying to find the minimum
temperature for a given day. I can find the min temperature on a given day
with this:
{=MIN(IF(TEXT($A$7:$A$2001,"mmm,d")=X127,$D$7:$D$2 001))} where X127 has the
day of the month I'm searching for and the low temperatures are in column
"D". But now I want the day it occurred which is in column "A" of the same
row as the min temp. How do I get that? I thought this would work;
{=ADDRESS(ROWS(D7:D2001=Z127),1)} but that gives me an erroneous address.

Another question: If I have the correct result from the 'ADDRESS()'
function above, how do I access the data in that cell that is referenced as a
text value?

Thanks for your help!

Doug