Hello... I attached a file to help you setup a formula that I need...

Basically the user types in the Item# in cell "H4"

Then the formula searches an array of cells "C5:C18" to find the matching Item#
Then it SUMS the amount shown in column "B" for all the matches found (sometimes more than one is found)
The returned result is shows the TOTAL QUANTITY in cell "H6"


Thanks!
See Attachment!

Excel 97-2003:
Match_Sum.xls