I use Excel to track orders and sales for sports teams. My formula: =IF(ISNA(VLOOKUP(B2,Roster!$B$2:$D$105,2,0)),"End List",IF(VLOOKUP(B2,Roster!$B$2:$D$105,2,0)=0,"",VLOOKUP(B2,Roster!$B$2:$D$105,2,0))) works fine except... Other formulas I use on the sheet are so large I can't use it on teams with over 40 individuals. My solution is to break it up over multiple sheets. I need the formula above (which I pieced together from a number of tutorials) to: Sheet 1 add names from the roster 1-40, which it does, sheet 2 names 41-81 and so on. Any Ideas?
Bookmarks