Matching Criteria

[yuenk]

I have a data base which is sheet 1 and an extract which is sheet 2. I want to take the total from the sheet 2 and have it to be populated into my total in sheet 1 with the matching criterias. How would I get the corresponding total from sheet 2?


Sheet 1

Serial #	Name	Total
123456	Thomas
7890	Joespeh

Sheet 2

Serial #	Name	Total
123456	Thomas	55
7890	Joeseph	40

Thanks

[JieJenn]

=SUMPRODUCT(--(Sheet2!$A$2:$A$3=Sheet1!A2),--(Sheet2!$B$2:$B$3=Sheet1!B2),(Sheet2!$C$2:$C$3))

[Tony Valko]

Another way...

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