Compare scores weekly

[Jerk24]

Good morning

I am working on Excel 07. and need to do the following

For a 12 team sports league that i want to caculate the teams total score for PTs for and PTs against

I have a Macro puts the teams total score in AE5:AP5 (Team 1-Team 12)

I would like the teams score to be added to cell AH106 for Team 1, AI106 for team 2, and so on to AS106 for Team 12. I will up date the table automatically each week so i need this to happen each time i run the macro

then i need to compare the schedule below to caculate for Teams that play each other.
this number needs to be added to the value in cells AF108 for Team 1, AF109 for team2, and so on AF119 for Team 12.

AE26:AG31 -

11	vs	12
7	vs	8
1	vs	2
9	vs	10
5	vs	6
3	vs	4

<tbody>
</tbody>

 

[Jerk24]

So i Created this table to make things easier i can copy down the scores that each team scored.

now is there a formula that will find the teams that faced each other and put the respective scores in the points againts table.

I looked at index and match, just cannot get it right

the table for pts for is in AH88:AS105 this is where i will copy the scores for the 12 team. AG87:AS87 as the team number (1-12)

AK108:AK119 is the week that i want to compare the schedule that is in above in my previous post (AE26:AG31)

Please help

 

[Jerk24]

bump