Looking up value that has two comparison values

C

Charlene79

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
separate sheet and post the Amount. As you can see the Item #'s ca
repeat as well as the Pieces. I am not sure what type of function t
use as the simple VLookup will not work since there are two criteria.

Thanks
 
T

Toppers

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
 
Top