Hello, I'm trying to see if there is a Formula to look up (2 Vlookup formulas to get 1 result)? And since I there isn't a place for me to attach a .xlsm or .xls file to show you. I'll have to explain below.
Example: I have a Tournament of 20 teams, and each Team plays each other and I have the layout like this.......
"Team A" (A2) "Team A" Score (B2) "Team B" (C2) "Team B" Score (D2)
"Team C" (A3) "Team C" Score (B3) "Team D" (C3) "Team D" Score (D3)
"Team E" (A4) "Team E" Score (B4) "Team F" (C4) "Team F" Score (D4) etc.
The result that I want to find is... when the Score is put in the (B2) or (D2) for the First game, I want another section like (H2)&(I2) & (J2)&(K2) 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.
John
Example: I have a Tournament of 20 teams, and each Team plays each other and I have the layout like this.......
"Team A" (A2) "Team A" Score (B2) "Team B" (C2) "Team B" Score (D2)
"Team C" (A3) "Team C" Score (B3) "Team D" (C3) "Team D" Score (D3)
"Team E" (A4) "Team E" Score (B4) "Team F" (C4) "Team F" Score (D4) etc.
The result that I want to find is... when the Score is put in the (B2) or (D2) for the First game, I want another section like (H2)&(I2) & (J2)&(K2) 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.
John
