Example:

Item # Pieces Amount
1973-M 48 3472
1973-M 100 4694
1974-N 48 3200

I need to match the Item # and Pieces to the Item # and Pieces in a
separate sheet and post the Amount. As you can see the Item #'s can
repeat as well as the Pieces. I am not sure what type of function to
use as the simple VLookup will not work since there are two criteria.

Thanks!


--
Charlene79
------------------------------------------------------------------------
Charlene79's Profile: http://www.excelforum.com/member.php...o&userid=35230
View this thread: http://www.excelforum.com/showthread...hreadid=550073

Try:

=SUMPRODUCT(--(A1:A100=Sheet2!item #),--(B1:B100=Sheet2!Pieces),C1:C100)

whete item# and pieces are cells in Sheet2


SUMPRODUCT must a range: it cannot be a column i.e A:A is invalid.

HTH

"Charlene79" wrote:


Example:

Item # Pieces Amount
1973-M 48 3472
1973-M 100 4694
1974-N 48 3200

I need to match the Item # and Pieces to the Item # and Pieces in a
separate sheet and post the Amount. As you can see the Item #'s can
repeat as well as the Pieces. I am not sure what type of function to
use as the simple VLookup will not work since there are two criteria.

Thanks!


--
Charlene79
------------------------------------------------------------------------
Charlene79's Profile: http://www.excelforum.com/member.php...o&userid=35230
View this thread: http://www.excelforum.com/showthread...hreadid=550073