Dear MrExcel

I have to find the value of the latest date, based on 3 criteria:

Column A = range criteria 1 (A1:A10)

Column B = range criteria 2 (B1:B10)

Column C = range criteria 3 (C1:C10)

Column D = range of the value/number (D1:D10)

Column E = range of the date (E1:E10)

A12 = criteria 1

A13 = criteria 2

A14 = criteria 3

How to write the formula in A15 to get the number in column D, only for the latest date?

Thanks so much, I really-really hope that somebody would like to help me.

Regards

I have to find the value of the latest date, based on 3 criteria:

Column A = range criteria 1 (A1:A10)

Column B = range criteria 2 (B1:B10)

Column C = range criteria 3 (C1:C10)

Column D = range of the value/number (D1:D10)

Column E = range of the date (E1:E10)

A12 = criteria 1

A13 = criteria 2

A14 = criteria 3

How to write the formula in A15 to get the number in column D, only for the latest date?

Thanks so much, I really-really hope that somebody would like to help me.

Regards

*EDIT: Based on criteria 1, criteria 2, criteria 3 at once.*
Last edited by a moderator: