Dear All,
Please find the first sheet as follows:
PO# Part Number Qty Purchased Qty
Received
4734LA004 3-1439-6 6
by formula?

While the second sheet as follows:
PO# Part Number Qty Received
Date of Received
4734LA004 3-1439-6 1
1Mar05
4734LA004 3-1439-6 2
10Mar05
4734LA004 3-1439-6 1
1 April05

how is the right coding for formula : to get the result in Sheet 1, column
Qty Received to reflect 4ea. Has tried Sum, frequency, index, and match
function, still not able to solve...
the Match Criteria: that PO# AND ("&") Part Number is must be equal between
sheet 1 and sheet 2.

Need your help, plz :)

Brgds,andri