Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum multiple matches to a vlookup command | Excel Worksheet Functions | |||
Vlookup Multiple Matches | Excel Worksheet Functions | |||
VLOOKUP and multiple matches | Excel Discussion (Misc queries) | |||
Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
how to deal with multiple matches on vlookup? | Excel Discussion (Misc queries) |