Spreadsheet: 824166d1680346771-how-can-i-make-the-table_array-in-vlookup-function-dynamic-moving-between-series-of-data-template
Sheet: Sheet1

Day | Date | Channel | Hotel A | Hotel B | Hotel C | Hotel D | Hotel E | Hotel F | Hotel G | Hotel H | Hotel I | Hotel J
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | Agoda_ | 324 | 425 | 337 | 300 | 287 | 323 | 355 | 700 | 283 | 234
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | Booking.com | 275 | 500 | 338 | 300 | 250 | 324 | 356 | 700 | NR | 235
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | BookingMobApp | 292 | 450 | 338 | 255 | 288 | 324 | 338 | 700 | 283 | 212
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | Brand | 280 | 500 | 338 | 236 | 280 | 292 | 375 | - | 222 | NP
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | GDS | 280 | 500 | 570 | 270 | 280 | 324 | 375 | 595 | NP | NP
1900-01-02 00:00:00 | 2023-02-13 00:00:00 | Tripadvisor | 269 | 424 | 337 | 243 | 212 | 324 | 324 | 610 | 218 | NP
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | Agoda_ | 324 | 424 | 337 | 269 | 252 | 323 | 354 | 668 | 264 | 234
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | Booking.com | 275 | 500 | 338 | 270 | 288 | 324 | 356 | 670 | NR | 235
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 288 | 324 | 338 | 670 | 265 | 212
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | Brand | 247 | 500 | 297 | 240 | 280 | 292 | 400 | - | 210 | NP
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | GDS | 280 | 500 | 570 | 270 | 280 | 324 | 375 | 570 | NP | NP
1900-01-03 00:00:00 | 2023-02-14 00:00:00 | Tripadvisor | 280 | 425 | 337 | - | 212 | 322 | 324 | 644 | 210 | NP
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | Agoda_ | 324 | 424 | 337 | 270 | 251 | 389 | 399 | 668 | 264 | 234
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | Booking.com | 325 | 500 | 316 | 270 | 266 | 390 | 380 | 670 | NR | 235
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 288 | 390 | 360 | 670 | 281 | 212
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | Brand | 247 | 500 | 297 | 295 | 280 | 351 | 400 | - | 210 | NP
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | GDS | 280 | 500 | 570 | 270 | 280 | 390 | 400 | 570 | NP | NP
1900-01-04 00:00:00 | 2023-02-15 00:00:00 | Tripadvisor | 269 | 424 | 335 | 243 | 212 | 380 | 346 | 603 | 210 | NP
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | Agoda_ | 329 | 424 | 337 | 283 | 276 | 350 | 344 | 670 | 264 | 223
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | Booking.com | 325 | 500 | 338 | 284 | 276 | 351 | 380 | 672 | NR | 223
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | BookingMobApp | 292 | 450 | 338 | 241 | 312 | 351 | 360 | 672 | 281 | 201
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | Brand | 269 | 500 | 297 | 315 | 280 | 333 | 360 | - | 210 | NP
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | GDS | 280 | 500 | 405 | 284 | 280 | 351 | 360 | 672 | NP | NP
1900-01-05 00:00:00 | 2023-02-16 00:00:00 | Tripadvisor | 270 | 425 | 337 | 255 | 212 | 342 | 326 | 577 | 210 | NP
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 289 | 350 | 364 | 644 | 264 | 223
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 276 | 351 | 380 | 646 | NR | 223
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 312 | 351 | 360 | 646 | 265 | 201
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | Brand | 306 | 500 | 297 | 240 | 280 | 333 | 360 | - | 210 | NP
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | GDS | 306 | 500 | 405 | 270 | 280 | 351 | 360 | 646 | NP | NP
1900-01-06 00:00:00 | 2023-02-17 00:00:00 | Tripadvisor | 266 | 425 | 337 | 243 | 212 | 342 | 327 | 644 | 210 | NP
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 250 | 350 | 344 | 722 | 264 | 223
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 288 | 351 | 355 | 723 | NR | 223
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | BookingMobApp | 292 | 450 | 316 | 270 | 288 | 351 | 360 | 722 | 265 | 201
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | Brand | 269 | 500 | 297 | 295 | 280 | 333 | 360 | - | 210 | NP
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | GDS | 306 | 500 | 405 | 270 | 280 | 351 | 360 | 722 | NP | NP
1900-01-07 00:00:00 | 2023-02-18 00:00:00 | Tripadvisor | 261 | 424 | 337 | 243 | 212 | 351 | 326 | 700 | 210 | NP
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 287 | 350 | 364 | 680 | 264 | 223
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 288 | 351 | 380 | 680 | NR | 223
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 288 | 351 | 360 | 680 | 265 | 201
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | Brand | 269 | 500 | 338 | 240 | 280 | 333 | 360 | - | 210 | NP
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | GDS | 306 | 500 | - | 270 | 280 | 351 | 360 | 680 | NP | NP
1900-01-01 00:00:00 | 2023-02-19 00:00:00 | Tripadvisor | 266 | 424 | 337 | 251 | 212 | 349 | 312 | 678 | 208 | NP
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 276 | 333 | 331 | 576 | 264 | 223
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 288 | 333 | 380 | 663 | NR | 223
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 288 | 333 | 360 | 663 | 265 | 201
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | Brand | 269 | 500 | 338 | 295 | 280 | 317 | 340 | - | 210 | NP
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | GDS | 306 | 500 | 382 | 270 | 280 | 333 | 400 | 663 | NP | NP
1900-01-02 00:00:00 | 2023-02-20 00:00:00 | Tripadvisor | 266 | 424 | 337 | 243 | 212 | 325 | 311 | 578 | 210 | NP
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 335 | 333 | 331 | 593 | 264 | 223
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 288 | 333 | 380 | 595 | NR | 223
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | BookingMobApp | 292 | 450 | 324 | 230 | 288 | 333 | 360 | 595 | 281 | 201
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | Brand | 269 | 500 | 297 | 295 | 280 | 317 | 340 | - | 210 | NP
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | GDS | 306 | 500 | 382 | 270 | 280 | 333 | 400 | 595 | NP | NP
1900-01-03 00:00:00 | 2023-02-21 00:00:00 | Tripadvisor | 254 | 425 | 337 | 243 | 212 | 325 | 308 | 592 | 210 | NP
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | Agoda_ | 323 | 424 | 338 | 269 | 232 | 333 | 331 | 604 | 264 | 223
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 278 | 333 | 380 | 604 | NR | 223
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 288 | 333 | 360 | 604 | 265 | 201
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | Brand | 269 | 500 | 297 | 295 | 350 | 317 | 340 | - | 210 | NP
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | GDS | 306 | 500 | 382 | 270 | 350 | 333 | 400 | 604 | NP | NP
1900-01-04 00:00:00 | 2023-02-22 00:00:00 | Tripadvisor | 266 | 424 | 337 | 243 | 212 | 325 | 312 | 600 | 210 | NP
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | Agoda_ | 323 | 425 | 337 | 283 | 289 | 333 | 331 | 585 | 264 | 223
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | Booking.com | 324 | 500 | 338 | 284 | 282 | 333 | 380 | 587 | NR | 223
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | BookingMobApp | 292 | 450 | 338 | 241 | 302 | 333 | 360 | 586 | 265 | 201
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | Brand | 269 | 500 | 297 | 252 | 315 | 317 | 340 | - | 210 | NP
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | GDS | 306 | 500 | 382 | 284 | 315 | 333 | 400 | 586 | NP | NP
1900-01-05 00:00:00 | 2023-02-23 00:00:00 | Tripadvisor | 266 | 424 | 335 | 255 | 212 | 325 | 312 | 560 | 210 | NP
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 276 | 333 | 342 | 636 | 227 | 223
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | Booking.com | 261 | 500 | 338 | 270 | 282 | 333 | 380 | 638 | NR | 223
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 302 | 333 | 360 | 638 | 265 | 201
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | Brand | 269 | 500 | 297 | 295 | 315 | 317 | 340 | - | 210 | NP
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | GDS | 306 | 500 | 382 | 270 | 315 | 333 | 400 | 638 | NP | NP
1900-01-06 00:00:00 | 2023-02-24 00:00:00 | Tripadvisor | 261 | 425 | 337 | 243 | 212 | 325 | 312 | 634 | 210 | NP
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 289 | 333 | 344 | 570 | 264 | 223
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 302 | 333 | 380 | 570 | NR | 223
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 302 | 333 | 360 | 570 | 265 | 201
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | Brand | 269 | 500 | 297 | 240 | 315 | 317 | 340 | - | 210 | NP
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | GDS | 306 | 500 | 382 | 270 | 315 | 333 | 400 | 570 | NP | NP
1900-01-07 00:00:00 | 2023-02-25 00:00:00 | Tripadvisor | 261 | 425 | 337 | 243 | 212 | 325 | 308 | 567 | 210 | NP
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 276 | 333 | 331 | 560 | 264 | 223
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 302 | 333 | 323 | 561 | NR | 223
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 302 | 333 | 323 | 561 | 265 | 201
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | Brand | 269 | 500 | 297 | 240 | 315 | 317 | 340 | - | 210 | NP
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | GDS | 306 | 500 | - | 270 | 315 | 333 | 400 | 561 | NP | NP
1900-01-01 00:00:00 | 2023-02-26 00:00:00 | Tripadvisor | 266 | 424 | 337 | 243 | 212 | 325 | 316 | 560 | 210 | NP
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 264 | 333 | 344 | 551 | 264 | 223
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | Booking.com | 324 | 500 | 338 | 270 | 302 | 333 | 380 | 553 | NR | 223
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 340 | 333 | 360 | 552 | 265 | 201
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | Brand | 269 | 500 | 297 | 240 | 351 | 317 | 340 | - | 210 | NP
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | GDS | 306 | 500 | 570 | 270 | 351 | 333 | 400 | 552 | NP | NP
1900-01-02 00:00:00 | 2023-02-27 00:00:00 | Tripadvisor | 266 | 424 | 337 | 243 | 212 | 325 | 312 | Closed | 210 | NP
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | Agoda_ | 323 | 424 | 337 | 269 | 276 | 333 | 342 | 543 | 264 | 223
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | Booking.com | 324 | 500 | 321 | 270 | 306 | 333 | 400 | 544 | NR | 223
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | BookingMobApp | 292 | 450 | 338 | 230 | 306 | 333 | 360 | 544 | 265 | 201
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | Brand | 269 | 500 | 297 | 295 | 332 | 317 | 340 | - | 210 | NP
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | GDS | 306 | 500 | 570 | 270 | 332 | 333 | 400 | 544 | NP | NP
1900-01-03 00:00:00 | 2023-02-28 00:00:00 | Tripadvisor | 306 | 424 | 331 | 261 | 246 | 325 | 308 | Closed | 210 | NP
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | Agoda_ | 323 | 424 | 411 | 269 | 285 | 328 | 332 | 561 | 252 | 284
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | Booking.com | 324 | 500 | 413 | 270 | 286 | 329 | 500 | 561 | NR | 285
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | BookingMobApp | 292 | 450 | 412 | 230 | 286 | 329 | 450 | 561 | 265 | 256
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | Brand | 306 | 500 | 363 | 240 | 382 | 313 | 383 | - | 210 | NP
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | GDS | 306 | 500 | - | 270 | 382 | 329 | 446 | 561 | NP | NP
1900-01-04 00:00:00 | 2023-03-01 00:00:00 | Tripadvisor | 270 | 425 | 331 | 243 | 246 | 329 | 312 | Closed | 210 | NP
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | Agoda_ | 323 | 425 | 411 | 283 | 276 | 341 | 344 | 543 | 265 | 284
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | Booking.com | 324 | 500 | 386 | 284 | 265 | 342 | 475 | 544 | NR | 285
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | BookingMobApp | 292 | 450 | 412 | 241 | 292 | 342 | 450 | 544 | 265 | 256
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | Brand | 269 | 500 | 363 | 252 | 382 | 325 | 383 | - | 210 | NP
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | GDS | 306 | 500 | - | 284 | 382 | 342 | 446 | 544 | NP | NP
1900-01-05 00:00:00 | 2023-03-02 00:00:00 | Tripadvisor | 270 | 424 | 331 | 255 | 246 | 342 | 308 | Closed | 210 | NP
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | Agoda_ | 323 | 424 | 412 | 269 | 255 | 337 | 344 | 771 | 264 | 284
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | Booking.com | 324 | 500 | 413 | 270 | 292 | 338 | 475 | 774 | NR | 285
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | BookingMobApp | 292 | 450 | 412 | 230 | 292 | 338 | 450 | 774 | 265 | 256
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | Brand | 306 | 500 | 363 | 295 | 382 | 321 | 383 | - | 210 | NP
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | GDS | 306 | 500 | 670 | 270 | 382 | 338 | 446 | 774 | NP | NP
1900-01-06 00:00:00 | 2023-03-03 00:00:00 | Tripadvisor | 279 | 425 | 331 | 243 | 246 | 337 | 307 | Closed | 210 | NP
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | Agoda_ | 323 | 424 | 411 | 270 | 276 | 328 | 344 | 636 | 264 | 284
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | Booking.com | 324 | 500 | 413 | 270 | 286 | 329 | 475 | 638 | NR | 285
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | BookingMobApp | 292 | 450 | 386 | 230 | 286 | 329 | 450 | 638 | 265 | 256
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | Brand | 269 | 500 | 363 | 295 | 382 | 313 | 383 | - | 210 | NP
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | GDS | 306 | 500 | - | 270 | 382 | 329 | 446 | 638 | NP | NP
1900-01-07 00:00:00 | 2023-03-04 00:00:00 | Tripadvisor | 302 | 424 | 331 | 243 | 246 | 329 | 312 | Closed | 210 | NP