Darth_Williams
New Member
- Joined
- Oct 15, 2015
- Messages
- 25
Good afternoon all,
Can I pick your collective minds for a second. I am looking to create a training passport whereby I would enter a team leader name and I would get the results from every person in that team.
So A column lists the team members, B column lists the team leaders, C column onwards shows the various training each person has received.
In essence, if I put Dave Williams in the team leader cell, then the following cells underneath will bring back the results for everyone who has Dave Williams as their team leader. My initial thought would be to use an INDEX MATCH (well my first thought was to do this in a pivot table but my line manager didn't like this) but I'm not sure that would work.
Any thoughts, hints and or tips will be most welcome.
Thanks
Dave.
Can I pick your collective minds for a second. I am looking to create a training passport whereby I would enter a team leader name and I would get the results from every person in that team.
So A column lists the team members, B column lists the team leaders, C column onwards shows the various training each person has received.
In essence, if I put Dave Williams in the team leader cell, then the following cells underneath will bring back the results for everyone who has Dave Williams as their team leader. My initial thought would be to use an INDEX MATCH (well my first thought was to do this in a pivot table but my line manager didn't like this) but I'm not sure that would work.
Any thoughts, hints and or tips will be most welcome.
Thanks
Dave.