| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sum multiple matches to a vlookup command
I need to run a vlookup for an exact value in a range and for each match
calculate the total of the cell adjacent. For example, James appears in this list twice and I want to reach a sum of his sales listed. I know I can do a vlookup command, but I'm not sure what to do when there are multiple matches. Thanks! Name Sales Name Total Sales James $120 James Bob $168 Bob Randy $65 Randy James $54 Henry Henry $796 Pete Pete $164 Alfred Bob $638 Alfred $945 Randy $12 Henry $578 Alfred $324 Pete $179 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP and multiple matches | Excel Discussion (Misc queries) | |||
| Can vlookup be used to retrieve multiple matches | Excel Discussion (Misc queries) | |||
| Vlookup to return the sum of multiple matches | Excel Discussion (Misc queries) | |||
| How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
| Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
