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
Bookmarks