XL_CLUELESS
New Member
- Joined
- Mar 14, 2017
- Messages
- 2
I am hoping to return the number of hours that matches 3 criteria. For example For project 100 where R1 is the Project Manager I would like to return how many hours each resource did in part 1 of the project in one column and return the value of the amount of hours she did for Part 2.
<tbody>
</tbody>
Hope this makes sense. All help is appreciated. I tried using Index Match functions but I keep getting a N/A value.
A | B | C | D | E | F | G | H | I | J | |||||||
1 | Project | PM | Resource1 | Resource2 | Resource3 | Resource4 | Resource5 | Resource6 | Resource7 | |||||||
Part1 | Part2 | Part1 | Part2 | Part1 | Part2 | Part1 | Part2 | Part1 | Part2 | Part1 | Part2 | Part1 | Part2 | |||
2 | 100 | R1 | 15 | 2 | 6 | 5 | ||||||||||
3 | 200 | R2 | 10 | 1 | 3 | |||||||||||
4 | 300 | R3 | 2 | 1 | 2 | 7 | 8 | |||||||||
5 | 400 | R1 | 22 | 2 | ||||||||||||
6 | 500 | R3 | 3 | 12 | 5 | 17 | 8 | 1 | 1 | |||||||
7 | 600 | R4 | 8 | 5 | 6 | 7 | ||||||||||
8 | 700 | R1 | 1 | 2 | 8 | |||||||||||
9 | 800 | R4 | 5 | 16 | ||||||||||||
10 | 900 | R2 | 22 | 1 | 5 | 12 | ||||||||||
11 | 110 | R3 | 8 | 2 | 8 | 1 |
<tbody>
</tbody>
Hope this makes sense. All help is appreciated. I tried using Index Match functions but I keep getting a N/A value.