Copy Paste Rows by Column Criteria

Originally Posted by FDibbins

If you base the extract on the TeamID in TeamPlayerLinks column H, using this (looking in to Teams)...
=INDEX(teams.xlsx!A$2:A$21,MATCH($H2,teams.xlsx!AP$2:AP$21,0))

This will produce teh exact same results for every row with the same TeamID. Is this what you want??

Not sure what you mean ?

Using the teams workbook or the Team ID Reference workbook ?

I would prefer the Team ID Reference workbook as the list used to search rather than the teams workbook.

When I use the players/teams formula I enter the formula in cell B2 of either reference workbook I get exactly what I want.

I think it would be harder using the teams workbook seeing there is already so much data in the workbook and the fact that
the teamplayerlinks workbook I sent you is only some of the teams in the full workbook, if i were to use the full workbook I
would be getting data I may not be looking for.