jcaptchaos2
Wellknown Member
 Joined
 Sep 24, 2002
 Messages
 1,032
 Office Version

 365
 Platform

 Windows
I have this formula that has been working well until now. It will not allow any more vlookup additions. Is there another way to do this?
Code:
=IF(ISNA(VLOOKUP($D4,Game1!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game1!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game2!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game2!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game3!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game3!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game4!$C$4:$F$28,2,FALSE)),0,VLOOKUP($D4,Game4!$C$4:$F$28,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game5!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game5!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game6!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game6!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game7!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game7!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game8!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game8!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game9!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game9!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game10!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game10!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game11!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game11!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game12!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game12!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game13!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game13!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game14!$C$4:$F$35,2,FALSE)),0,VLOOKUP($D4,Game14!$C$4:$F$35,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game15!$C$4:$F$36,2,FALSE)),0,VLOOKUP($D4,Game15!$C$4:$F$36,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game16!$C$4:$F$31,2,FALSE)),0,VLOOKUP($D4,Game16!$C$4:$F$31,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game17!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game17!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game18!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game18!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game19!$C$4:$F$26,2,FALSE)),0,VLOOKUP($D4,Game19!$C$4:$F$26,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game20!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game20!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game21!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game21!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game22!$C$4:$F$33,2,FALSE)),0,VLOOKUP($D4,Game22!$C$4:$F$33,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game23!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game23!$C$4:$F$29,2,FALSE))+IF(ISNA(VLOOKUP($D4,Game24!$C$4:$F$29,2,FALSE)),0,VLOOKUP($D4,Game24!$C$4:$F$29,2,FALSE))