Hi,
I have table of team and resources in tab 1, I also have a second table of teams alongside team members in tab 2.
I want to pull through the resources based in tab 1 that are marked as true through to tab 2 but I want the resource names.
In my head it would be something along the lines of.
If tab 2 column 1 cell 2, is in tab 1 column 2 cell 1, and tab 1 column 2 cell 2 is true, then pull through tab 1 column 1 cell 2, to tab 2 column 3 cell 2
Thanks in advance everyone.
Mr Cat
I have table of team and resources in tab 1, I also have a second table of teams alongside team members in tab 2.
I want to pull through the resources based in tab 1 that are marked as true through to tab 2 but I want the resource names.
In my head it would be something along the lines of.
If tab 2 column 1 cell 2, is in tab 1 column 2 cell 1, and tab 1 column 2 cell 2 is true, then pull through tab 1 column 1 cell 2, to tab 2 column 3 cell 2
Thanks in advance everyone.
Mr Cat