I was thinking along the lines of the right side of the sheet, where I have multiple teams and the points scored and against them each week. I have a long Index/Match formula retrieving said points each week. Is there a way, using VBA, to cut that down to just a shorter formula to get the points and also not using the 0's and 1's in row 26 and others? Or maybe also using names on the left side to get said points? There's only two choices of getting the points for each week, and there's points for(PF), and points against(PA). When you reply, would you post in English please?