Hello,
I am working on a spreadsheet that has the following setup. What would be the best way to find out which projects each person is on? I was thinking of doing a vlookup, but I would like to know if there is a better alternative.
<tbody>
</tbody>
Thanks,
RCA
I am working on a spreadsheet that has the following setup. What would be the best way to find out which projects each person is on? I was thinking of doing a vlookup, but I would like to know if there is a better alternative.
Project | Resource 1 | Resource 2 | Resource 3 | Resource 4 |
1 | Ana | Rob | Jim | Erica |
2 | Rob | Susan | Tim | Kyle |
<tbody>
</tbody>
Thanks,
RCA