Spreadsheet: 120219d1315088323-two-conditions-meet-one-condition-is-within-data-set-search-for-corresponding-value-example
Sheet: rawdata

ID | Name | Skl 1 | Lvl 1 | Skl 2 | Lvl 2 | Skl 3 | Lvl 3 | Skl 4 | Lvl 4 | Skl 5 | Lvl 5 | Skl 6 | Lvl 6 | Skl 7 | Lvl 7 | Skl 8 | Lvl 8 | Skl 9 | Lvl 9 | Skl 10 | Lvl 10 | Skl 11 | Lvl 11 | Skl 12 | Lvl 12 | Skl 13 | Lvl 13 | Skl 14 | Lvl 14 | Skl 15 | Lvl 15 | Skl 16 | Lvl 16 | Skl 17 | Lvl 17
1104 | name 1 | 186 | 6 | 183 | 1 | 185 | 1
1105 | name 2 | 186 | 3
1106 | name 3 | 192 | 1 | 182 | 1 | 199 | 1 | 195 | 1 | 198 | 2 | 196 | 2 | 194 | 2 | 190 | 2 | 193 | 2 | 184 | 4 | 197 | 2 | 200 | 2 | 201 | 1 | 187 | 4 | 189 | 3
1107 | name 4 | 182 | 1 |  |  | 186 | 1 |  |  |  |  | 198 | 1 | 196 | 1 | 183 | 1 |  |  |  |  |  |  |  |  |  |  | 192 | 1
1108 | name 5 | 186 | 3 | 194 | 1 | 196 | 1 | 198 | 1
1109 | name 6 | 183 | 5 | 186 | 6
1110 | name 7 | 182 | 1 | 192 | 1 | 183 | 2 | 184 | 1 | 186 | 4 | 199 | 1 | 195 | 1 | 190 | 3 | 193 | 3 | 197 | 3 | 194 | 2 | 200 | 3 | 196 | 2 | 198 | 2 | 201 | 1 | 187 | 6 | 189 | 3
1113 | name 8 | 187 | 2 | 189 | 4 | 197 | 2 | 193 | 2 | 192 | 3 | 190 | 2 | 200 | 2 | 186 | 2 | 198 | 1 | 196 | 1 | 194 | 1 | 182 | 3 | 195 | 3 | 199 | 3 | 201 | 3 | 184 | 3
1114 | name 9 | 186 | 6 | 183 | 5
1115 | name 10 | 182 | 2 | 189 | 6 | 190 | 2 | 194 | 1 | 199 | 2 | 198 | 1 | 196 | 1 | 195 | 2 | 187 | 4 | 184 | 4 | 193 | 2 | 192 | 2 | 197 | 2 | 201 | 2 | 200 | 2 | 186 | 6
1116 | name 11 | 182 | 2 | 198 | 1 | 195 | 2 | 189 | 2 | 190 | 4 | 192 | 2 | 196 | 1 | 193 | 4 | 194 | 1 | 186 | 5 | 184 | 3 | 187 | 6 | 199 | 2 | 197 | 4 | 200 | 4 | 201 | 2
1117 | name 12 | 189 | 1 | 187 | 1 | 197 | 1 | 193 | 1 | 190 | 1 | 200 | 1 | 194 | 2 | 196 | 2 | 198 | 2 | 182 | 1
1118 | name 13 | 190 | 5 | 193 | 5 | 197 | 5 | 200 | 5 | 183 | 1 | 187 | 6 | 189 | 7
1119 | name 14 | 190 | 1 | 182 | 6 | 195 | 6 | 199 | 6 | 192 | 1 | 193 | 3 | 189 | 4 | 197 | 3 | 200 | 1 | 201 | 1
1120 | name 15 | 199 | 1 | 182 | 3 | 192 | 3 | 195 | 3 | 194 | 1 | 196 | 1 | 198 | 1 | 190 | 2 | 187 | 2 | 189 | 4 | 200 | 2 | 201 | 3 | 193 | 2 | 197 | 2 | 184 | 4
1121 | name 16 | 186 | 1
1122 | name 17 | 186 | 2 | 199 | 1 | 182 | 1 | 195 | 1 | 192 | 1 | 201 | 1 | 194 | 2 | 196 | 2 | 198 | 2 | 184 | 2 | 187 | 5 | 189 | 6 | 190 | 4 | 193 | 4 | 197 | 4 | 200 | 4
1123 | name 18 | 183 | 4 | 186 | 1
1124 | name 19 | 182 | 2 | 195 | 2 | 192 | 2 | 189 | 3 | 199 | 2 | 196 | 1 | 198 | 1 | 190 | 2 | 194 | 1 | 184 | 4 | 193 | 2 | 197 | 2 | 187 | 4 | 200 | 2 | 201 | 2
1125 | name 20 | 196 | 4 | 198 | 4 | 194 | 4 | 182 | 1 | 184 | 2 | 197 | 3 | 186 | 5 | 193 | 3 | 189 | 6 | 190 | 3 | 195 | 1 | 183 | 2 | 199 | 1 | 200 | 3 | 192 | 1 | 201 | 1 | 187 | 5
1126 | name 21 | 182 | 1 | 200 | 4 | 184 | 2 | 186 | 2 | 192 | 1 | 195 | 1 | 194 | 2 | 190 | 4 | 189 | 5 | 196 | 2 | 198 | 2 | 199 | 1 | 197 | 4 | 187 | 6 | 193 | 4 | 201 | 1
1127 | name 22 | 183 | 5 | 184 | 5 | 186 | 5 | 194 | 3 | 196 | 3 | 198 | 3 | 192 | 3 | 182 | 3 | 195 | 3 | 199 | 3 | 201 | 3
1128 | name 23 | 192 | 1 | 182 | 1 | 195 | 1 | 199 | 2 | 200 | 2 | 194 | 2 | 198 | 2 | 196 | 1 | 201 | 2 |  |  | 187 | 1 | 189 | 2
1129 | name 24 | 196 | 2 | 198 | 2 | 194 | 2 | 193 | 1 | 182 | 3 | 197 | 1 | 190 | 1 | 192 | 3 | 200 | 1 | 195 | 3 | 199 | 3 | 201 | 3 |  |  | 184 | 2 | 189 | 4
1130 | name 25 | 200 | 1 | 197 | 1 | 193 | 1 | 201 | 1 | 190 | 1 | 199 | 3
1133 | name 26 | 198 | 2 | 199 | 1 | 182 | 3 | 194 | 2 | 196 | 2 | 195 | 1 | 192 | 1 | 200 | 4 | 201 | 1 | 190 | 4 | 184 | 2 | 183 | 3 | 193 | 4 | 197 | 4 | 186 | 2 | 189 | 5 | 187 | 6
1134 | name 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 | 3 |  |  | 186 | 1
1136 | name 28 | 190 | 1 | 193 | 1 | 197 | 1 | 200 | 1 | 198 | 2 | 194 | 2 | 196 | 2 | 201 | 3 | 192 | 3 | 195 | 3 | 199 | 3 | 182 | 3
1138 | name 29 | 186 | 6 | 185 | 1
1140 | name 30 | 189 | 4 | 200 | 1 | 197 | 1 | 190 | 1 | 187 | 4 | 193 | 1 | 194 | 2 | 196 | 2 | 198 | 2
1141 | name 31 | 182 | 1 | 183 | 2 | 186 | 3 | 192 | 1 | 195 | 1 | 196 | 2 | 198 | 2 | 199 | 1 | 194 | 2 | 201 | 1 | 187 | 6 | 189 | 5 | 184 | 3 | 190 | 5 | 193 | 5 | 197 | 5 | 200 | 5
1176 | name 32 | 190 | 1 | 193 | 1 | 197 | 1 | 200 | 1 | 184 | 1 | 194 | 1 | 196 | 1 | 198 | 1
1178 | name 33 | 190 | 1 | 193 | 1 | 197 | 1 | 200 | 1
1184 | name 34 | 200 | 1 | 197 | 1 | 193 | 1 | 190 | 1
1185 | name 35 | 200 | 1 | 197 | 1 | 193 | 1 | 190 | 1
1187 | name 36 |  |  | 197 | 1 | 193 | 2
1188 | name 37 | 188 | 1
1189 | name 38 | 200 | 1 | 197 | 1 | 193 | 2 | 190 | 1
1190 | name 39 | 190 | 1 | 193 | 1 | 197 | 1 | 200 | 1
1191 | name 40 | 182 | 1
1192 | name 41 | 200 | 5 | 190 | 5 | 193 | 5 | 197 | 5 | 194 | 2 | 196 | 2 | 198 | 2 | 183 | 1 | 192 | 4 | 182 | 4 | 195 | 4 | 199 | 4 | 201 | 4 | 187 | 4 | 184 | 3
1193 | name 42 | 200 | 7 | 190 | 7 | 193 | 7 | 197 | 7 | 198 | 7 | 196 | 7 | 194 | 7 | 182 | 7 | 192 | 7 | 195 | 7 | 199 | 7 | 201 | 7 | 187 | 7 | 184 | 7 | 186 | 1
1195 | name 43 |  |  | 197 | 2 | 193 | 2
1196 | name 44 | 190 | 2 | 193 | 2 | 197 | 2 | 200 | 2 | 184 | 1 | 194 | 1 | 196 | 7 | 198 | 1 | 192 | 4 | 182 | 4 | 195 | 4 | 199 | 4 | 201 | 1
1198 | name 45 | 194 | 1 | 193 | 1 | 197 | 1 | 200 | 1 | 190 | 1 | 196 | 1 | 198 | 1