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