I've created a 15 week dart league workbook and want to be able to track up
to eight teams playing each week. There are four data/score sheets in each
worksheet and one worksheet for each week. (i.e 2 teams playing against
eachother in each
scoresheet) The problem I'm having is getting the 4th score sheet to post to
my master stats worksheet due to "Formula too long." I basically index/match
each of the four scoresheets for a specific player...Here's the formula for
one player...

$C$305 =player's name, 'Mstr Stats'!$D307=the stat to look for
'WK 1'!$A$32:$W$56=the tabulated scores of the first two team's game
'WK 1'!$B$32:$B$56=the player name match
'WK 1'!$A$32:$W$32=the stat match(i.e. Ton 80's) and so on...to the
second,third or fourth game (but I can't enter the fourth table due to
"formula too long error" Imagine that???)

=IF(ISERROR(INDEX('WK 1'!$A$32:$W$56,MATCH($C$305,'WK
1'!$B$32:$B$56,0),MATCH('Mstr Stats'!$D307,'WK
1'!$A$32:$W$32,0))),0,(INDEX('WK 1'!$A$32:$W$56,MATCH($C$305,'WK
1'!$B$32:$B$56,0),MATCH('Mstr Stats'!$D307,'WK
1'!$A$32:$W$32,0))))+IF(ISERROR(INDEX('WK 1'!$Z$32:$AU$56,MATCH($C$305,'WK
1'!$Z$32:$Z$56,0),MATCH('Mstr Stats'!$D307,'WK
1'!$Z$32:$AU$32,0))),0,(INDEX('WK 1'!$Z$32:$AU$56,MATCH($C$305,'WK
1'!$Z$32:$Z$56,0),MATCH('Mstr Stats'!$D307,'WK
1'!$Z$32:$AU$32,0))))+IF(ISERROR(INDEX('WK 1'!$B$89:$W$111,MATCH($C$305,'WK
1'!$B$89:$B$111,0),MATCH('Mstr Stats'!$D307,'WK
1'!$B$89:$W$89,0))),0,(INDEX('WK 1'!$B$89:$W$111,MATCH($C$305,'WK
1'!$B$89:$B$111,0),MATCH('Mstr Stats'!$D307,'WK 1'!$B$89:$W$89,0))))

Any suggestions??? Could I 'Name' each table formula to consolidate the
formula and give more space for the fourth team game. I've gotten this far,
and I know there's a solution.