formulating if; then; enter list

[striker92s]

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

 

[Biff]

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