VLOOKUP or IF Function?

[carol]

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?

 

[Mike H]

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

 

[Pranav Vaidya]

Hi Carol,

Not sure how is your data looking like, but you can use combination of IF,
VLOOKUP, and COUNT

HTH,

 

[Max]

Try sumproduct ..

Eg: =SUMPRODUCT((A2:A100="hit")*B2:B100)
will return the sum of numbers in col B where col A contain the key text: hit

And if the key text: hit
could be part of a text string, eg: hit man, double hit, etc
you could use instead:
=SUMPRODUCT(ISNUMBER(SEARCH("hit",A2:A100))*B2:B100)

 

[vezerid]

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",D2100)

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

HTH
Kostis Vezerides

 

[carol]

Thanks max, that did it.

Sorry to everyone else for my info being vague!

 

[Max]

welcome, glad you got what you were after.