Spreadsheet: 856699d1705919001-vba-or-formula-index-match-issue-illustration-provided-help
Sheet: Sheet1

 |  |  | ID |  |  |  | location | Date
 |  |  | VisitID |  |  |  | location | Date:
 |  |  | 616 |  |  |  | Sembawang MRT Station | 28/11/23
 |  |  | 618 |  |  |  | 849 [NAME] | 30/11/23
 |  |  | 619 |  |  |  | Khatib MRT Station | 30/11/23
 |  |  | 620 |  |  |  | 925 Yishun Central | 01/12/23
 |  |  | 621 |  |  |  | Sembawang MRT Station | 01/12/23 | test
 |  |  | 622 |  |  |  | 135 Jurong Gateway Road | 28/11/23
 |  |  | 623 |  |  |  | 442 Clementi Ave 3 | 28/11/23
 |  |  | 624 |  |  |  | 213 Bedok North Street 1 | 28/11/23
 |  |  | 625 |  |  |  | Tampines MRT Trade Fair | 28/11/23
 |  |  | 626 |  |  |  | 682 [NAME] | 28/11/23
 |  |  | 627 |  |  |  | 29 Bendemeer | 29/11/23
 |  |  | 628 |  |  |  | 703 Ang Mo Kio | 30/11/23
 |  |  | 629 |  |  |  | [NAME] One | 30/11/23
 |  |  | 631 |  |  |  | 118 [NAME] | 01/12/23
 |  |  | 633 |  |  |  | [NAME] | 01/12/23
 |  |  | 634 |  |  |  | Serangoon Central Drive Trade Fair | 01/12/23
 |  |  | 639 |  |  |  | Tampines Giant | 29/11/23
 |  |  | 641 |  |  |  | 204 [NAME] 21 | 29/11/23
 |  |  | 642 |  |  |  | 303 Woodlands | 29/11/23
 |  |  | 643 |  |  |  | 282 Bishan Street 22 | 29/11/23
 |  |  | 644 |  |  |  | [NAME] One | 29/11/23
 |  |  | 645 |  |  |  | [NAME] | 29/11/23
 |  |  | 646 |  |  |  | Rivervale Plaza Trade Fair | 29/11/23
 |  |  | 647 |  |  |  | Khatib MRT Trade Fair | 29/11/23
 |  |  | 648 |  |  |  | Sembawang MRT Station | 29/11/23
 |  |  | 650 |  |  |  | 135 Jurong Gateway Road | 29/11/23
 |  |  | 651 |  |  |  | 442 Clementi Ave 3 | 29/11/23
 |  |  | 652 |  |  |  | 213 Bedok North Street 1 | 30/11/23
 |  |  | 653 |  |  |  | Tampines MRT Trade Fair | 30/11/23
 |  |  | 654 |  |  |  | 682 [NAME] | 30/11/23
 |  |  | 655 |  |  |  | 29 Bendemeer | 30/11/23
 |  |  | 656 |  |  |  | [NAME] One | 01/12/23
 |  |  | 657 |  |  |  | 849 [NAME] | 01/12/23
 |  |  | 658 |  |  |  | 703 Ang Mo Kio | 01/12/23
 |  |  | 659 |  |  |  | Khatib MRT Trade Fair | 01/12/23
 |  |  | 660 |  |  |  | Yew Tee MRT | 04/12/23
 |  |  | 661 |  |  |  | 443 Clementi Ave 3 | 04/12/23
 |  |  | 662 |  |  |  | 260 Bangkit Road | 04/12/23
 |  |  | 663 |  |  |  | Jurong East Bus Interchange | 04/12/23
 |  |  | 664 |  |  |  | 846 [NAME] | 04/12/23
 |  |  | 665 |  |  |  | Khatib MRT Trade Fair | 04/12/23
 |  |  | 666 |  |  |  | 925 Yishun Central | 04/12/23
 |  |  | 667 |  |  |  | 727 Ang Mo Kio Ave 6 | 04/12/23
 |  |  | 668 |  |  |  | Serangoon Central Drive | 04/12/23
 |  |  | 669 |  |  |  | [NAME] | 05/12/23
 |  |  | 670 |  |  |  | Khatib MRT | 05/12/23
 |  |  | 671 |  |  |  | 925 Yishun Central | 05/12/23
 |  |  | 672 |  |  |  | 727 Ang Mo Kio Ave 6 | 05/12/23
 |  |  | 675 |  |  |  | Yew Tee MRT | 05/12/23
 |  |  | 676 |  |  |  | 442 Clementi Ave 3 | 05/12/23
 |  |  | 792 |  |  |  | 375 Bukit Batok | 28/12/2023
 |  |  | 791 |  |  |  | 303 Woodlands St 31 | 28/12/2023
 |  |  | 790 |  |  |  | 207 [NAME] Lay | 28/12/2023
 |  |  | 789 |  |  |  | [NAME] | 27/12/2023
 |  |  | 788 |  |  |  | 539 Bedok North | 27/12/2023
 |  |  | 787 |  |  |  | Serangoon Central Drive | 27/12/2023
 |  |  | 786 |  |  |  | 375 Bukit Batok | 27/12/2023
 |  |  | 785 |  |  |  | 303 Woodlands St 31 | 27/12/2023
 |  |  | 784 |  |  |  | 207 [NAME] Lay | 27/12/2023
 |  |  | 783 |  |  |  | [NAME] | 26/12/2023
 |  |  | 782 |  |  |  | 539 Bedok North | 26/12/2023
 |  |  | 781 |  |  |  | Serangoon Central Drive | 26/12/2023
 |  |  | 780 |  |  |  | 19 Marsling Lane | 24/12/2023
 |  |  | 778 |  |  |  | Yew Tee MRT | 22/12/2023
 |  |  | 777 |  |  |  | 207 Boon Lay Trade Fair | 22/12/2023
 |  |  | 776 |  |  |  | 443 Clementi Ave 3 | 18/12/2023
 |  |  | 775 |  |  |  | [NAME] | 22/12/2023
 |  |  | 774 |  |  |  | 19 Marsling Lane | 22/12/2023
 |  |  | 772 |  |  |  | Yew Tee MRT | 21/12/2023
 |  |  | 771 |  |  |  | 207 Boon Lay Trade Fair | 21/12/2023
 |  |  | 770 |  |  |  | 443 Clementi Ave 3 | 21/12/2023
 |  |  | 769 |  |  |  | keat Hong Shopping Centre | 21/12/2023
 |  |  | 768 |  |  |  | 498 Jurong West St 41 | 21/12/2023
 |  |  | 767 |  |  |  | 504 Jurong West St 51 | 21/12/2023
 |  |  | 766 |  |  |  | [NAME] | 21/12/2023
 |  |  | 764 |  |  |  | 702 Ang Mo Kio Avenue 8 | 21/12/2023
 |  |  | 763 |  |  |  | 418 Yishun Avenue 11 | 21/12/2023
 |  |  | 762 |  |  |  | Toa Payoh Bus Interchange | 21/12/2023
 |  |  | 760 |  |  |  | 498 Jurong West St 41 | 20/12/2023
 |  |  | 759 |  |  |  | 504 Jurong West St 61 | 20/12/23
 |  |  | 758 |  |  |  | [NAME] | 20/12/23
 |  |  | 755 |  |  |  | 301 Ubi Avenue 1 | 19/12/2023
 |  |  | 754 |  |  |  | 204 [NAME] 21 | 19/12/2023
 |  |  | 753 |  |  |  | 253 to 264 Serangoon Central | 19/12/2023
 |  |  | 752 |  |  |  | [NAME] | 19/12/2023
 |  |  | 751 |  |  |  | 301 Ubi Avenue 1 | 10/12/2023
 |  |  | 750 |  |  |  | 204 [NAME] 21 | 20/12/2023
 |  |  | 749 |  |  |  | 253 to 264 Serangoon Central | 20/12/23
 |  |  | 748 |  |  |  | [NAME] | 20/12/23
 |  |  | 747 |  |  |  | 702 Ang Mo Kio Ave 8 | 19/12/2023
 |  |  | 746 |  |  |  | 418 Yishun Avenue 11 | 19/12/2023
 |  |  | 745 |  |  |  | Toa Payoh Bus Interchange | 19/12/23
 |  |  | 742 |  |  |  | 504 Jurong West St 41 | 15/12/2023
 |  |  | 741 |  |  |  | 526 Ang Mo Kio Avenue 10 | 15/12/23
 |  |  | 740 |  |  |  | 192 Lorong 4 Toa Payoh | 15/12/23
 |  |  | 739 |  |  |  | 925 Yishun Central | 15/12/23
 |  |  | 738 |  |  |  | 105 Canberra | 17/12/23
 |  |  | 737 |  |  |  | Singapore Expo | 15/12/23
 |  |  | 736 |  |  |  | 960 Jurong West St 92 | 17/12/23
 |  |  | 615 |  |  |  | 282 Bishan St 22 | 28/11/23
 |  |  | 614 |  |  |  | Khatib MRT Trade Fair | 28/11/23
 |  |  | 613 |  |  |  | 303 Woodlands | 28/11/23
 |  |  | 612 |  |  |  | 204 [NAME] 21 | 27/11/23
 |  |  | 611 |  |  |  | [NAME] | 27/11/23
 |  |  | 610 |  |  |  | [NAME] | 27/11/23
 |  |  | 609 |  |  |  | [NAME] One | 27/11/23
 |  |  | 608 |  |  |  | Tampines MRT Trade Fair | 27/11/23
 |  |  | 607 |  |  |  | Tampines Giant | 27/11/23
 |  |  | 606 |  |  |  | 282 Bishan | 23/11/23
 |  |  | 605 |  |  |  | [NAME] | 24/11/23
 |  |  | 604 |  |  |  | Khatib MRT Trade Fair | 24/11/23
 |  |  | 603 |  |  |  | Kallang Wave Mall | 24/11/23
 |  |  | 602 |  |  |  | [NAME] One | 24/11/23
 |  |  | 601 |  |  |  | 729 Ang Mo Kio Central | 24/11/23
 |  |  | 600 |  |  |  | 925 Yishun Centeal | 24/11/23
 |  |  | 599 |  |  |  | 254A Serangoon Central Dr | 22/11/23
 |  |  | 598 |  |  |  | [NAME] | 22/11/23
 |  |  | 597 |  |  |  | [NAME] One | 23/11/23
 |  |  | 596 |  |  |  | Tampines MRT | 23/11/23
 |  |  | 595 |  |  |  | 531 Ang Mo Kio Ave 10 | 24/11/23
 |  |  | 594 |  |  |  | 258 Bukit Panjang | 22/11/23
 |  |  | 593 |  |  |  | Bugis MRT | 22/11/23
 |  |  | 592 |  |  |  | Khatib MRT Trade Fair | 20/11/23
 |  |  | 591 |  |  |  | One North MRT | 24/11/23
 |  |  | 590 |  |  |  | 158 Toa Payoh | 24/11/23
 |  |  | 589 |  |  |  | 305 Woodlands St 31 | 20/11/23
 |  |  | 588 |  |  |  | 849 [NAME] | 20/11/23
 |  |  | 587 |  |  |  | 40 Beo Cresent | 20/11/23
 |  |  | 586 |  |  |  | Aljunied Cresent | 22/11/23
 |  |  | 581 |  |  |  | 846 [NAME] | 17/11/23
 |  |  | 580 |  |  |  | 260 Bukit Panjang Road | 17/11/23
 |  |  | 579 |  |  |  | Telok Blangah Cresent | 17/11/23
 |  |  | 578 |  |  |  | Clarke Quay NEL | 16/11/23
 |  |  | 577 |  |  |  | 30 Woodlands Ave 1 The Woodgrove | 16/11/23
 |  |  | 576 |  |  |  | 4 Changi Village | 16/11/23
 |  |  | 575 |  |  |  | Bugis MRT | 16/11/23
 |  |  | 574 |  |  |  | 431 Clementi Avenue 3 | 20/11/23
 |  |  | 566 |  |  |  | [NAME] | 18/11/23
 |  |  | 565 |  |  |  | [NAME] | 18/11/23
 |  |  | 564 |  |  |  | [NAME] | 18/11/23
 |  |  | 562 |  |  |  | 728 Ang Mo Kio | 20/11/23
 |  |  | 561 |  |  |  | 925 Yishun Central | 20/11/23
 |  |  | 560 |  |  |  | 305 Woodlands | 20/11/23
 |  |  | 558 |  |  |  | Tampines MRT | 16/11/23
 |  |  | 557 |  |  |  | 18 Tai Seng Street | 16/11/23
 |  |  | 556 |  |  |  | [NAME] | 16/11/23
 |  |  | 554 |  |  |  | [NAME] | 17/11/23
 |  |  | 553 |  |  |  | Toa Payoh Bus Interchange | 17/11/23
 |  |  | 552 |  |  |  | 702 Ang Mo Kio | 15/11/23
 |  |  | 677 |  |  |  | Jurong East Bus Interchange | 05/12/23
 |  |  | 679 |  |  |  | [NAME] | 06/12/23
 |  |  | 680 |  |  |  | 204 [NAME] 21 | 06/12/23
 |  |  | 681 |  |  |  | Habourfront NEL | 06/12/23
 |  |  | 685 |  |  |  | 137A Tampines St 11 | 06/12/23
 |  |  | 686 |  |  |  | 821 Tampines St 81 | 06/12/23
 |  |  | 687 |  |  |  | [NAME] | 07/12/23
 |  |  | 688 |  |  |  | 204 [NAME] 21 | 08/12/23
 |  |  | 689 |  |  |  | Habourfront NEL | 08/12/23
 |  |  | 690 |  |  |  | Blk 19 Marsiling Lane | 08/12/23
 |  |  | 691 |  |  |  | 825 Woodlands St 81 Booth | 08/12/23
 |  |  | 692 |  |  |  | 825 Woodlands St 81 Booth | 07/12/23
 |  |  | 693 |  |  |  | Bedok Town Square Trade Fair | 10/12/23
 |  |  | 694 |  |  |  | 303 Woodlands Street | 08/12/23
 |  |  | 695 |  |  |  | Khatib MRT | 08/12/23
 |  |  | 696 |  |  |  | KHATIB MRT | 07/12/23
 |  |  | 697 |  |  |  | 303 Woodlands Street | 07/12/23
 |  |  | 698 |  |  |  | KHATIB MRT | 11/12/23
 |  |  | 700 |  |  |  | BLK 183 TOA PAYOH CENTRAL | 11/12/23
 |  |  | 701 |  |  |  | BLK 211 TOA PAYOH TRADE FAIR LOT NO. TBC | 11/12/23
 |  |  | 703 |  |  |  | 925 YISHUN CENTRAL 1 | 11/12/23
 |  |  | 705 |  |  |  | 303 WOODLANDS #01-179 | 11/12/23
 |  |  | 706 |  |  |  | 498 JURONG WEST STREET 41 OCBC JURONG WEST ST 41, SINGAPORE 640498 | 11/12/23
 |  |  | 709 |  |  |  | Blk 204 [NAME] 21 | 12/12/23
 |  |  | 710 |  |  |  | 722 Clementi West St 2 | 12/12/23
 |  |  | 711 |  |  |  | Serangoon Trade Fair | 12/12/23
 |  |  | 712 |  |  |  | Khatib MRT | 14/12/2023
 |  |  | 713 |  |  |  | Blk 211 Toa Payoh | 12/12/23
 |  |  | 714 |  |  |  | Blk 183 Toa Payoh | 12/12/23
 |  |  | 715 |  |  |  | 925 Yishun Central 1 | 12/12/23
 |  |  | 716 |  |  |  | 303 Woodlands | 12/12/23
 |  |  | 717 |  |  |  | 498 Jurong West St 41 | 12/12/23
 |  |  | 718 |  |  |  | YEW TEE POINT | 12/12/23
 |  |  | 719 |  |  |  | BEDOK TOWN SQUARE TRADE FAIR | 13/12/2023
 |  |  | 720 |  |  |  | [NAME] ROAD MARKET #01-157 S430013 | 13/12/2023
 |  |  | 721 |  |  |  | 505 TAMPINES YELLOW BOX, #01-337A | 13/12/2023
 |  |  | 722 |  |  |  | 116 ALJUNIED AVE #01-73 | 13/12/2023
 |  |  | 725 |  |  |  | Yew Tee Point | 14/12/2023
 |  |  | 726 |  |  |  | Bedok Town Square Trade Fair | 14/12/2023
 |  |  | 727 |  |  |  | [NAME] | 14/12/2023
 |  |  | 728 |  |  |  | 505 Tampines #01-337A | 14/12/2023
 |  |  | 729 |  |  |  | 925 Yishun Central 1 | 14/12/2023
 |  |  | 730 |  |  |  | 192 Lorong 4 Toa Payoh | 14/12/2023
 |  |  | 731 |  |  |  | 526 Ang Mo Kio Avenue 10 | 14/12/2023
 |  |  | 732 |  |  |  | 504 Jurong West st 41 | 14/12/2023
 |  |  | 734 |  |  |  | 21 [NAME] | 15/12/2023
 |  |  | 735 |  |  |  | Khatib MRT | 15/12/2023
 |  |  | 463 |  |  |  | 105 Canberra St | 7/10/2023
 |  |  | 464 |  |  |  | [NAME] | 08/10/23
 |  |  | 465 |  |  |  | SEMBAWANG MRT STATION | 07/10/23
 |  |  | 466 |  |  |  | 152 [NAME] | 07/10/23
 |  |  | 467 |  |  |  | 106 Canberra | 10/10/23
 |  |  | 468 |  |  |  | 445 [NAME] | 13/10/23
 |  |  | 469 |  |  |  | 821 Tampines | 13/10/23
 |  |  | 470 |  |  |  | 218 [NAME] (Trade Fair) | 12/10/23
 |  |  | 471 |  |  |  | Suntec City Level 1 | 07/10/23
 |  |  | 472 |  |  |  | [NAME] Bedok Int | 06/10/23
 |  |  | 483 |  |  |  | [NAME] | 13/10/23
 |  |  | 484 |  |  |  | Buangkok NEL | 12/10/23
 |  |  | 485 |  |  |  | 928 Yishun Central | 10/10/23
 |  |  | 486 |  |  |  | 177 Toa Payoh Central | 12/10/23
 |  |  | 487 |  |  |  | City Plaza | 18/10/23
 |  |  | 488 |  |  |  | 720 Ang Mo Kio | 20/10/23
 |  |  | 489 |  |  |  | 505 Tampines | 18/10/23
 |  |  | 490 |  |  |  | 154 Bukit Batok | 18/10/23
 |  |  | 491 |  |  |  | Woodlands Trade Fair | 18/10/23
 |  |  | 492 |  |  |  | [NAME] | 20/10/23
 |  |  | 493 |  |  |  | Century Square | 18/10/23
 |  |  | 494 |  |  |  | 354 Clementi Ave | 20/10/23
 |  |  | 495 |  |  |  | Woodlands MRT Trade Fair | 20/10/23
 |  |  | 508 |  |  |  | Clementi Bus Interchange | 25/10/23
 |  |  | 509 |  |  |  | 13 Haig Road | 26/10/23
 |  |  | 510 |  |  |  | 702 Ang Mo Kio | 26/10/23
 |  |  | 511 |  |  |  | 266 Serangoon Central | 26/10/23
 |  |  | 512 |  |  |  | 127 Toa Payoh Lor 1 | 26/10/23
 |  |  | 513 |  |  |  | 108 Canberra Street | 26/10/23
 |  |  | 514 |  |  |  | 492 Jurong West | 25/10/23
 |  |  | 515 |  |  |  | Suntec City | 24/10/23
 |  |  | 523 |  |  |  | 503 Tampines Central | 01/11/23
 |  |  | 531 |  |  |  | 695 [NAME] | 08/11/23
 |  |  | 535 |  |  |  | 18 Jalan Membina | 01/11/23
 |  |  | 536 |  |  |  | 278 Bukit Batok East | 02/11/23
 |  |  | 537 |  |  |  | 498 Jurong West St 41 | 02/11/23
 |  |  | 538 |  |  |  | 345 Jurong East St 31
 |  |  | 539 |  |  |  | 925 Yishun | 06/11/23
 |  |  | 540 |  |  |  | 726 [NAME] | 06/11/23
 |  |  | 541 |  |  |  | 503 Tampines Central | 08/11/23
 |  |  | 542 |  |  |  | Blk 305 Woodlands Street 23 | 10/11/23
 |  |  | 543 |  |  |  | 114 Aljunied NTUC | 08/11/23
 |  |  | 544 |  |  |  | Oxley Tower Event Space 2 | 07/11/23
 |  |  | 545 |  |  |  | 201E Tampines Street 23 | 08/11/23
 |  |  | 546 |  |  |  | Blk 418 [NAME] | 10/11/23
 |  |  | 547 |  |  |  | 103 [NAME] | 10/11/23
 |  |  | 548 |  |  |  | 45238 | 07/02/22
 |  |  | 549 |  |  |  | Blk 925 Yishun Central | 10/11/23
 |  |  | 550 |  |  |  | 727 [NAME] | 10/11/23
 |  |  | 551 |  |  |  | 106 [NAME] | 16/11/23
 |  |  | 793 |  |  |  | 253 Serangoon Central Drive | 29/12/23
 |  |  | 795 |  |  |  | 253 Serangoon Central Drive | 30/12/23