Formula to return a value based on criteria

[helpme20]

I am looking for a formula to produce a value based on the last date.

Column A is the Product Name
Column B is the Date of Purchase
Column C is the Product Cost by Unit of Measure


Can someone help me with the formula in Column D to return the Last Product Cost (Column C) for the most recent purchase (Column B) of the Product name (Column A) ?


Thank you very much.

Brian

 

[Aladin Akyurek]

Yes, that did work as well. Thank you for checking this one.

Great. Thanks for the update.

 

[markmzz]

By the way, for the first formula (array formula) to work, you must to press Ctrl+Shift+Enter to enter the formula.

Here is one more formula (with the AGGREGATE function):

=IF(COUNTIF(A$2:A2,A2)>1,"",
AGGREGATE(14,6,1/(B$2:B$17=LARGE((A$2:A$17=A2)*B$2:B$17,1))*C$2:C$17,1))<strike></strike>

Markmzz
​

<strike></strike>