Help with VLookUp Formula in adding values.

[PixelPug]

I am trying to add values in different lists for total amount needed. I am using the following formula:

Please Login or Register  to view this content.

The formula works for the first item, however it seems to add values if they match any part of the word. For example, the first value is Blazing Crystal with two matches that add up to 6. This is correct in the result. However, the second entry, which is Blazing Gem only has 2 total items yet it returns a value of 8.

Is there a formula or macro that can make it work the way I want it to?

[JohnTopley]

In B2 and copy down

=SUMIF(J:J,A2,K:K)

[PixelPug]

In B2 and copy down

=SUMIF(J:J,A2,K:K)

Thanks, that did exactly what I wanted.