Vlookup with multiple matches
 

How can i use the vlookup function to find multiple matches in a single
column and to sum them. All values are numbers. I've been fighting with
this issue too long and cannot solve it. Problem seems to bee that
vlookup "stops" on the first exact match. Do i have to use a custom
function?

Vlookup with multiple matches
 

You might provide a simple illustration and what result you are
expecting. It sounds to me like the following would do what you
describe, but that isn't the way J.E. McGimpsey interpreted what you are
asking:

=SUMIF(a1:a100, 8) if the numbers youu are trying to sum are all 8's.

Alan Beban

J.E. McGimpsey wrote:
One way:

Instead of

=VLOOKUP(A1, B:C, 2, 0)

use

=SUMPRODUCT(B1:B1000=A1)*(C1:C1000))

In article ,
BubBob wrote:


How can i use the vlookup function to find multiple matches in a single
column and to sum them. All values are numbers. I've been fighting with
this issue too long and cannot solve it. Problem seems to bee that
vlookup "stops" on the first exact match. Do i have to use a custom
function?