Find last value and show its date from another column

[proficient]

Hi all,

I have 2 columns, one has dates inn it and other has daily production, I want to search the last date based on last day prodduction, to which I ma using below formula

=INDEX($F$3:$F$29,MATCH(INDEX(G3:$G$29,COUNTA($G$3:$G$29)),$G$3:$G$29,0))

But here is a problem, if there are same production on 2 or more dates like ( on 1-March 1000, and on 3-March 1000 units also then as a result it shows 1-March instead of 3-March. I need last output date.

 

[proficient]

I am done

=INDEX($F$3:$F$29,COUNTA($G$3:$G$29),0)

 

[Aladin Akyurek]

Also:

=LOOKUP(9.99999999999999E+307,$G$3:$G$29,$F$3:$F$29)

 

[proficient]

I was expecting you Thank you so much Guru.

 

[Aladin Akyurek]

You are welcome.