Hi!

Not sure what "saved team players in pivot table format"
means.

Here's an example of a table and the formula to use.

Col L = team names starting in L1
Col M and N = players names starting in M1,N1

Team 1 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12

Team 2 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12

Team 3 Player 1 Player 7
Player 2 Player 8
Player 3 Player 9
Player 4 Player 10
Player 5 Player 11
Player 6 Player 12



Select the range H4:I9.
Enter this formula in the FORMULA BAR as an array by using
the key combo of CTRL,SHIFT,ENTER

=IF(A5="","",OFFSET(L1,MATCH(A5,L1:L100,0)-1,1,6,2))

Biff

-----Original Message-----

13 teams, saved team players in pivot table format (also
first time user
for pivot table)


--
striker92s
----------------------------------------------------------
--------------
striker92s's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16559
View this thread:
http://www.excelforum.com/showthread...hreadid=314186

.