Carol,

A bit short on info but this looks in column A for the valkue in C1 and
then sums any corresponding values in column B.

=SUMIF(A:A,C1,B:B)

Mike

"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?