Hi,

I'm trying to use Sumproduct to lookup up a unique value in a range of cells. The range is for updated costs with the first row containing the date, the second row containing the supplier and the first column containing the product. This is what I have so far:

=SUMPRODUCT((a2:a10=PRODUCT)*(b1:g1<=DATE)*(b2:g2=SUPPLIER),b3:g10)

I want the formula to find the most recent entry after DATE, however I've only been able to sum the and entries previous to DATE. Is there a way to add another criteria to only sum/lookup the most recent entry?

Thanks