NON blank corresponding value of most recent date

[freefe]

Hello everybody. I am new to the forum and already found lot of helpful info, Thanks!
I am looking for a formula that looks into 2 columns, one containing dates and one values, and returning the corresponding value of the latest date.
So far so good i found working for me:
=INDEX(H10:H13,MATCH(MAX(L10:L13),L10:L13,0))
where dates are in L10:L13 and values in H10:H13.
What I just can NOT get is how to get as a result the value comparable to the second most recent date, in case the most recent date has 0 o no value?
Any idea?
Thanks,
F

[rylo]

Hi

Try
=INDEX(H10:H13,MATCH(LARGE(L10:L13,2),L10:L13,0))

rylo

[freefe]

Rylo, thanks for your reply. That give in result the corresponding vale of the second latest date.
I am still looking for the value of the latest date with a value corresponding. That would be the latest date, unless there is no value (or 0) and if so it would give the next latest date with a value.
Any idea?

[rylo]

Hi

Sorry misunderstood what you were chasing. Try this

=INDEX(H10:H13,MATCH(MAX(IF(H10:H13>0,L10:L13)),L10:L13,0))

It has to be array entered (CTRL, SHIFT, ENTER)

rylo

[freefe]

Perfect! Thanks a million, it works like a charm!
I really appreciate your help!
Best,
F