Lookup multiple values in multiple columns and return value

Try:

=SUMIFS(Ark2!C:C,Ark2!A:A,A2,Ark2!B:B,B2)

if there are multiple matches, the results will be summed, if that is not what you want let me know.

Hi,

This would be easier if you had Excel 2007 since you could use SUMIFS.

Use a helper column D on Ark2 and concatenate the A&B cells. e.g. =A2&B2

Then in C2 on Ark1 and copied down use

Please Login or Register  to view this content.

Wrap it in an =IF(ISERROR(formula above),"",formula above) if you wish to avoid '#N/A's

HTH