One way...

Data Range
A
B
C
D
E
F
1
Team1
Team2
Team3
Team4
Team5
2
Week1
53
33
72
75
93
3
Week2
19
53
71
89
45
4
Week3
99
87
63
11
97
5
Week4
72
42
41
79
60
6
Week5
45
95
82
90
81
7
8
9
Week3
Team4
11


This formula entered in C9:

=VLOOKUP(A9,A1:F6,MATCH(B9,A1:F1,0),0)