Hello, I'm trying to see if there is a way to get Formula to look up 2 (Vlookup formulas to get 1 result)? Then in part 2, I'm trying to get a Team Points and Opponents Points total. When I try to do a "SUM" in cell AF4, =SUM(T4,V4,X4,Z4,AB4,AD4) and also in cell AG4, =SUM(U4,W4,Y4,Z4,AA4,AC4) It would give me a #Value! or a "0" error.
Example: I have a Tournament of 20 teams, and each Team plays each other and I have the layout like this.......
"Team A" (B4) "Team A" Score (C4) "Team B" (D4) "Team B" Score (E4)
"Team C" (B5) "Team C" Score (C5) "Team D" (D5) "Team D" Score (E5)
"Team E" (B6) "Team E" Score (C6) "Team F" (D6) "Team F" Score (E6) etc.
The result that I want to find is... when the Score is put in the (C4) or (E4) for the First game, I want another section like (I4)&(K4) & (N4)&(P4) to display Team Results for (Points For & Points Against). I have a file I can send you to clear up any confusion that I'm asking.
Thanks for your help,
John
Bookmarks