What I would do is set up the players as a table, each team on a
separate row. You then set the first element of the row equal to the
team number (so you have A1 = 1, A2 = Team 1, player 1, A3 = Team 1,
player 1 jersey number, A4 = Team 1, player 2... and so on). You then
use Vlookup to extract that information from the table, using the team
number as the reference to get the correct row. A bit of a dirty hack,
I'm afraid, but I have yet to find another way of doing it without
getting into macros.