Team Period Average

Update the output cells so that each row displays the average score for the team in column B and the location in column C based on the employee data table in columns F:K where column G matches the team in column B and column H matches the location in column C. The period to average (P1, P2, or P3) is determined by the text in C7 and corresponds to one of the period columns I:K. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50