Hello,
Apologies if this is the wrong place to post, or has been answered before but this is my first post and im not sure how to explain what I am trying to do so couldn't search for it.
I currently have a spreadsheet with a list of Team Members next to a Team Manager name on a sheet named data. There are anywhere between 10 - 20 teams at anyone time with between 8 and 20 members.
I then have separate sheets for each team to display some stats. It all works perfectly, the only issue I have is that when it comes to team changes, i have to manually update each team sheet.
What i am trying to do is use a kind of vlookup that checks the Team Manager name in cell $A$1 of the individual team sheets and then looks up the team from that data sheet. But any lookup i use only lists the first team member. I know the teams will never be bigger than 25 so I think i need 25 formulas in the cells to ensure everyone is displayed.
Im not sure if this is making any sense so i have attached a sample sheet.
Any help would be greatly appreciated.
Many thanks
Stuart.
Bookmarks