brunetti92
New member
- Joined
- Jan 30, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I am have trouble creating an evaluation sheet for my employees. The goal is to print the total scans for each application in the second table for the respective ID number. I have tried nested vlookup along with if statements but run into the problem with vlookup when there are multiple of the same ID numbers since vlookup stops at the first match. I have looked into index match but am not familiar with the formulas and get lost in long equations. Any help would be greatly appreciated.
A | B | C | |
1 | ID | Application | Total Scans |
2 | 1234 | beltsplit | 12500 |
3 | 1234 | primarysort | 1300 |
4 | 1234 | vpls | 4000 |
5 | 2345 | primarysort | 3000 |
6 | 2345 | vpls | 1200 |
7 | 3456 | beltsplit | 12000 |
8 | 3456 | vpls | 4200 |
9 | 3456 | primarysort | 2300 |
E | F | G | H | |
1 | ID | Beltsplit | PrimarySort | VPLS |
2 | 1234 | |||
3 | 2345 | |||
4 | 3456 |