Hi guys,
I'm not great with these Vlookups, how do I set a vlookup to add up any matches?
For example my data table has:
<tbody>
</tbody>
So when I do my Vlookup by the reference numbers (10001, 10002 etc) I want the result to give me for each 10001 = 1300, 10002 = 1487, 10003 = 292, 10004 = 636
How would I set this?
Thanks,
Andy
I'm not great with these Vlookups, how do I set a vlookup to add up any matches?
For example my data table has:
A | B | |
1 | 10001 | 846 |
2 | 10001 | 454 |
3 | 10002 | 662 |
4 | 10002 | 277 |
5 | 10002 | 548 |
6 | 10003 | 292 |
7 | 10004 | 367 |
8 | 10004 | 269 |
<tbody>
</tbody>
So when I do my Vlookup by the reference numbers (10001, 10002 etc) I want the result to give me for each 10001 = 1300, 10002 = 1487, 10003 = 292, 10004 = 636
How would I set this?
Thanks,
Andy