VLOOKUP is excellent for retrieving a single value, if one occurrence
of lookup value is expected. If you expect several occurrences and
want a sum of the results you will probably need SUMIF:

=SUMIF(B2:B100,"AJ-123",D2:D100)

This formula will search column B:B for occurrences of "AJ-123" and
sum corresponding entries in D:D.

HTH
Kostis Vezerides

On Dec 10, 5:03 pm, carol wrote:
Is it possible to use the VLOOKUP or IF function to firstly, search a column
for a particular word, then return the corresponding values from another
column and calculate multiple values if more than one word hit is found?