lawrence24
New Member
- Joined
- Dec 31, 2013
- Messages
- 21
Hello!
This is some sample data:
Sheet 1:
<tbody>
</tbody>
Sheet 2:
<tbody>
</tbody>
What I'm trying to do is calculate the total values in Header 3, 4 & 5 for each name.
So the table in Sheet 1 should be:
<tbody>
</tbody>
I can't figure out how to loop over VLOOKUP through the sheet, to match all instances of the names in Sheet 1!
Please help!
This is some sample data:
Sheet 1:
Name | Total |
Jackson | |
Amy | |
Meghan |
<tbody>
</tbody>
Sheet 2:
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 |
Oranges | XTPC | 2 | 0 | 1 | Honda | Jackson |
Apples | PPTC | 1 | 1 | 1 | Toyota | Jackson |
Pineapples | LTPC | 1 | 2 | 0 | Mazda | Amy |
Bananas | YRGH | 6 | 0 | 0 | Audi | Meghan |
<tbody>
</tbody>
What I'm trying to do is calculate the total values in Header 3, 4 & 5 for each name.
So the table in Sheet 1 should be:
Name | Total |
Jackson | 6 |
Amy | 3 |
Meghan | 6 |
<tbody>
</tbody>
I can't figure out how to loop over VLOOKUP through the sheet, to match all instances of the names in Sheet 1!
Please help!