mattyblueice
Board Regular
- Joined
- Jul 24, 2014
- Messages
- 85
- Office Version
- 365
- Platform
- MacOS
Hi I have a huge project sheet with dozens of projects along with tasks and the associated contacts. My source list is set up like this:
<tbody>
</tbody>
Each tab a is project with a all of the tasks and contacts, many of the tasks require multiple roles such as
<tbody>
</tbody>
The project name is located in Cell A1, but how do I get a index/match formula to pull in the multiple roles that are seperated by commas? Any help would be appreciated!
Thanks
Matt
Role | Proj A | Proj B | Proj C |
PM | Bob | Sue | Dan |
BA | Phil | Mike | Matt |
SME | Ryan | Jack | Larry |
<tbody>
</tbody>
Each tab a is project with a all of the tasks and contacts, many of the tasks require multiple roles such as
A5 | B5 | C5 |
Gather Requirements | PM, BA, SME | Formula here |
<tbody>
</tbody>
The project name is located in Cell A1, but how do I get a index/match formula to pull in the multiple roles that are seperated by commas? Any help would be appreciated!
Thanks
Matt