Welcome to the board.

A
B
C
D
E
F
G
1
201503
201504
201505
201506
2
varA index1
15
18
800
18
3
index2
12
18
18
18
4
varB index1
230
225
225
225
5
index2
230
225
225
225
6
varC index1
13
13
13
13
7
index2
13
13
17
13
8
9
10
row
11
0
varA
201503
index1
15
B11: =INDEX($A$2:$A$6, 2 * INT($A11/8) + 1)
12
1
varA
201504
index1
18
C11: =INDEX($C$1:$F$1, MOD($A11, 4) + 1)
13
2
varA
201505
index1
800
D11: =INDEX($B$2:$B$7, INT($A11/4) + 1)
14
3
varA
201506
index1
18
E11: =INDEX($C$2:$F$7, INT($A11/4) + 1, MOD($A11, 4) + 1)
15
4
varA
201503
index2
12
16
5
varA
201504
index2
18
17
6
varA
201505
index2
18
18
7
varA
201506
index2
18
19
8
varB
201503
index1
230
20
9
varB
201504
index1
225
21
10
varB
201505
index1
225
22
11
varB
201506
index1
225
23
12
varB
201503
index2
230
24
13
varB
201504
index2
225
25
14
varB
201505
index2
225
26
15
varB
201506
index2
225
27
16
varC
201503
index1
13
28
17
varC
201504
index1
13
29
18
varC
201505
index1
13
30
19
varC
201506
index1
13
31
20
varC
201503
index2
13
32
21
varC
201504
index2
13
33
22
varC
201505
index2
17
34
23
varC
201506
index2
13