Spreadsheet: 800095d1665488090-find-the-code-with-data-in-multiple-columns-find-the-code-1-
Sheet: Sheet1

 | DATA RANGE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULTS
 | Order | Code | Location | 1 | 2 | 3 | 4 | 5 | 6 | Sales | Amount |  | Order | Code | 1 | 2 | 3 | 4 | 5 | 6 | Sales | Amount |  |  |  | # | Code
 | 1 | A-1 | NYC | 165 | 167 | 169 | 171 | 173 | 175 | 5 | 1200 |  | 1 | B-1 | 177 | 179 | 181 | 183 | 185 | 187 | 5 | 1200 |  |  |  | 165 | A-1
 | 2 | A-2 | London | 172 | 174 | 176 | 178 | 180 | 182 | 3 | 100 |  | 2 | B-2 | 184 | 186 | 188 | 190 | 192 | 194 | 3 | 100 |  |  |  | 172
 | 3 | A-3 | Cairo | 197 | 199 | 201 | 203 | 205 | 207 | 3 | 2000 |  | 3 | B-3 | 209 | 211 | 213 | 215 | 217 | 219 | 3 | 2000 |  |  |  | 197
 | 4 | A-4 | x | 204 | 206 | 208 | 210 | 212 | 214 | 5 | 1200 |  | 4 | B-4 | 216 | 218 | 220 | 222 | 224 | 226 | 5 | 1200 |  |  |  | 204
 | 5 | A-5 | y | 229 | 231 | 233 | 235 | 237 | 239 | 0 | 100 |  | 5 | B-5 | 241 | 243 | 245 | 247 | 249 | 251 | 0 | 100 |  |  |  | 229
 | 6 | A-6 | z | 236 | 238 | K | 242 | 244 | 246 | 1 | 2000 |  | 6 | B-6 | 248 | 250 | D | 254 | 256 | 258 | 1 | 2000 |  |  |  | 236
 | 7 | A-7 | London | 261 | 263 | 265 | 267 | 269 | 271 | 8 | 1200 |  | 7 | B-7 | 273 | 275 | 277 | 279 | 281 | 283 | 8 | 1200 |  |  |  | 261
 | 8 | A-8 | Cairo | 268 | 270 | 272 | 274 | 276 | 278 | 7 | 100 |  | 8 | B-8 | 280 | 282 | 284 | 286 | 288 | 290 | 7 | 100 |  |  |  | 268
 | 9 | [NAME] | x | 293 | 295 | 297 | 299 | 301 | 303 | 4 | 2000 |  | 9 | [NAME] | 305 | 307 | 309 | 311 | 313 | 315 | 4 | 2000 |  |  |  | 293
 | 10 | A-10 | y | 300 | 302 | 304 | 306 | 308 | 310 | 6 | 1500 |  | 10 | B-10 | 312 | 314 | 316 | 318 | 320 | 322 | 6 | 1500 |  |  |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 174
 | Order | Location | Code | 1 | 2 | 3 | 4 | 5 | 6 | Sales | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 199
 | 1 | NYC | C-1 | 189 | 191 | 193 | 195 |  |  | 5 | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206
 | 2 | London | C-2 | 196 | 198 | 200 | 202 |  |  | 3 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 231
 | 3 | Cairo | C-3 | 221 | 223 | 225 | 227 |  |  | 3 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 238
 | 4 | x | [NAME] | 228 | 230 | A | Z | 232 | 234 | 5 | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 263
 | 5 | y | C-5 | 253 | 255 | 257 | 259 |  |  | 0 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270
 | 6 | z | C-6 | 260 | 262 | 264 | 266 |  |  | 1 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 295
 | 7 | London | C-7 | 285 | 287 | 289 | 291 |  |  | 8 | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302
 | 8 | Cairo | C-8 | 292 | 294 | 296 | 298 |  |  | 7 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169
 | 9 | x | C-9 | 317 | 319 | 321 | 323 |  |  | 4 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 176
 | 10 | y | C-10 | 324 | 326 | 328 | 330 |  |  | 6 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 201
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 265
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 272
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 171
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 178
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 203
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 235
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 242
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 267
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 274
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 299
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 306
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 205
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 212
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 244
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 269
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 276
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 214
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 239
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 246
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 271
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 278
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 184
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 209
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 216
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 241
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 248
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 273
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 312
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 179
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 211
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 218
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 243
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 282
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 307
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 314