Excel 2007 : SUMPRODUCT with duplicate values

Dear All,

I have another problem. In the attched file i have a formula which match the value in first two columns and extract the third. It works fine only if the tha data is unique . But if any entry repeats it shows results as 0. Kindly advise is it possible if i can get the latest value from the data. Please see the attched sample for refrence.

Thanks & Regards

Here, try this:

=LOOKUP(2, 1/($A$2:$A$100&$B$2:$B$100=E6&F6), $C$2:$C$100)

Originally Posted by zbor

Here, try this:

=LOOKUP(2, 1/($A$2:$A$100&$B$2:$B$100=E6&F6), $C$2:$C$100)

Thanks a lot Sir. You have solved my problem.

Regards.