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??

This formula does not work for what I am trying to do, I would need the formula to use the Team ID Reference workbook for it's list to find IDs in the teamplayerlinks workbook.