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