Lookup Based on 2 Criteria

Hi all.

Can someone please help with a formula please.

I have a cost history list which I need to extract data from based on the last costing price.

Column A = Product code (Can be repeated many time)
Column B = Product Description (As above)
Column C = Costing Date
Column D = Cost Price


I want to look up the cost value based on the Product Code and the last costing date.

Many thanks



Diane