Spreadsheet: 462894d1464229349-multiple-criteria-vlookup-with-index-and-match-vlookup_q
Sheet: Sheet2

Postal Code |  |  | Group |  | ID |  | Postal | [NAME] |  |  | Postal Code |  |  |  |  |  |  |  |  |  |  | Bag |  | Postal | ID |  |  |  |  | Bag | Postal Code | Customer Code | Postal Code | Address | Time | Delivery Time Remarks | No. | Customer Code | Bag Equiv
670236 |  |  | 1 |  |  |  | 760175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 670236 | 1711 | 16 |  |  |  | 16 | 670236 | 1711 | 670236 | Bukit [NAME] | 10am to 1pm |  | 1 | 1711 | 16
640458 |  |  | 1 |  |  |  | 760125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 640458 | 1913 | 18 |  |  |  | 18 | 640458 | 1913 | 640458 | [NAME] | 10am to 1pm |  | 2 | 1913 | 18
640518 |  |  | 1 |  |  |  | 750469 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 640518 | 1750 | 16 |  |  |  | 16 | 640518 | 1750 | 640518 | [NAME] | 12pm | Try bf | 3 | 1750 | 16
649848 |  |  | 1 |  |  |  | 750422 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 649848 | 1801 | 15 |  |  |  | 15 | 649848 | 1801 | 649848 | [NAME] | 11am to 12pm | Strictly btwn | 4 | 1801 | 15
640977 |  |  | 1 |  |  |  | 791440 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 640977 | 1813 | 20 |  |  |  | 8 | 640977 | 1813 | 640977 | [NAME] | 10am to 1pm |  | 5 | 1813 | 8
641989 |  |  | 1 |  |  |  | 568402 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 641989 | 1977 | 16 |  |  |  | 12 | 640977 | 1813 | 640977 | [NAME] | 10am to 1pm |  | 6 | 1813 | 12
120118 |  |  | 2 |  |  |  | 550529 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 120118 | 1587 | 6 |  |  |  | 8 | 641989 | 1977 | 641989 | [NAME] | 1130am | Try bf | 7 | 1977 | 8
228192 |  |  | 2 |  |  |  | 530101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 228192 | 1875 | 11 |  |  |  | 8 | 641989 | 1977 | 641989 | [NAME] | 1130am | Try bf | 8 | 1977 | 8
180008 |  |  | 2 |  |  |  | 530952 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 180008 | 1751 | 32 |  |  |  | 6 | 120118 | 1587 | 120118 | [NAME] | 1230pm | Try bf | 9 | 1587 | 6
289850 |  |  | 2 |  |  |  | 543180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 289850 | 1854 | 23 |  |  |  | 11 | 228192 | 1875 | 228192 | [NAME] | 10-11am | Strictly btwn | 10 | 1875 | 11
760175 |  |  | 2 |  |  |  | 824617 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 760175 | 1572 | 14 |  |  |  | 28 | 180008 | 1751 | 180008 | Selegie Rd | 10-1pm |  | 11 | 1751 | 28
750469 |  |  | 2 |  |  |  | 510637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 750469 | 1562 | 22 |  |  |  | 4 | 180008 | 1751 | 180008 | Selegie Rd | 10-1pm |  | 12 | 1751 | 4
760125 |  |  | 3 |  |  |  | 524498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 760125 | 1680 | 14 |  |  |  | 23 | 289850 | 1854 | 289850 | Arcadia Rd | 10-1pm (Try as late as possible) |  | 13 | 1854 | 23
791440 |  |  | 3 |  |  |  | 522524 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 791440 | 1908 | 27 |  |  |  | 14 | 760175 | 1572 | 760175 | Yishun Ave 7 | 10-1pm |  | 14 | 1572 | 14
824617 |  |  | 3 |  |  |  | 521160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 824617 | 1775 | 13 |  |  |  | 15 | 750469 | 1562 | 750469 | [NAME] | 10-1pm |  | 15 | 1562 | 15
330022 |  |  | 3 |  |  |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 330022 | 1558 | 24 |  |  |  | 7 | 750469 | 1562 | 750469 | [NAME] | 10-1pm |  | 16 | 1562 | 7
310470 |  |  | 3 |  |  |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 310470 | 1871 | 20 |  |  |  | 4 | 760125 | 1680 | 760125 | [NAME] | 10-1pm |  | 17 | 1680 | 4
530101 |  |  | 3 |  |  |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 530101 | 1812 | 23 |  |  |  | 6 | 760125 | 1680 | 760125 | [NAME] | 10-1pm |  | 18 | 1680 | 6
550529 |  |  | 4 |  |  |  | 408934 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 550529 | 1843 | 13 |  |  |  | 4 | 760125 | 1680 | 760125 | [NAME] | 10-1pm |  | 19 | 1680 | 4
570134 |  |  | 4 |  |  |  | 439204 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 570134 | 1836 | 23 |  |  |  | 27 | 791440 | 1908 | 791440 | Fernvale Link | 12nn | Try bf | 20 | 1908 | 27
524498 |  |  | 4 |  |  |  | 49246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 524498 | 1717 | 11 |  |  |  | 13 | 824617 | 1775 | 824617 | Punggol Dr | 10-1pm |  | 21 | 1775 | 13
522524 |  |  | 4 |  |  |  | 18989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 522524 | 1919 | 30 |  |  |  | 24 | 330022 | 1558 | 330022 | [NAME] | 11am | Try aft | 22 | 1558 | 24
521160 |  |  | 4 |  |  |  | 90037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 521160 | 1876 | 18 |  |  |  | 20 | 310470 | 1871 | 310470 | Lor 6 Toa Payoh | 11-12pm | Strictly btwn | 23 | 1871 | 20
460412 |  |  | 4 |  |  |  | 68898 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 460412 | 1874 | 12 |  |  |  | 23 | 530101 | 1812 | 530101 | [NAME] | 10-1pm |  | 24 | 1812 | 23
460412 |  |  | 5 |  |  |  | 68898 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 460412 | new | 12 |  |  |  | 13 | 550529 | 1843 | 550529 | [NAME] | 10-1pm |  | 25 | 1843 | 13
460412 |  |  | 5 |  |  |  | 180008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 460412 | what if | 4 |  |  |  | 23 | 570134 | 1836 | 570134 | Bishan St.12 | 10-1pm |  | 26 | 1836 | 23
510637 |  |  | 5 |  |  |  | 189673 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 510637 | 1737 | 13 |  |  |  | 11 | 524498 | 1717 | 524498 | [NAME] 45 | 10-1pm |  | 27 | 1717 | 11
530952 |  |  | 5 |  |  |  | 228192 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 530952 | 1950 | 10 |  |  |  | 17 | 522524 | 1919 | 522524 | Tampines Central 7 | 10-1pm |  | 28 | 1919 | 17
049246 |  |  | 5 |  |  |  | 330022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 49246 | 8587 | 4 |  |  |  | 13 | 522524 | 1919 | 522524 | Tampines Central 7 | 10-1pm |  | 29 | 1919 | 13
090037 |  |  | 5 |  |  |  | 310470 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 90037 |  | 10 |  |  |  | 18 | 521160 | 1876 | 521160 | [NAME] 12 | 10-11am (try before 10.30am) | Strict betw | 30 | 1876 | 18
750422 |  |  | 6 |  |  |  | 570134 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 750422 | xxx | 2 |  |  |  | 12 | 460412 | 1874 | 460412 | Bedok North Ave 2 | 10-1pm |  | 31 | 1874 | 12
670423 |  |  | 6 |  |  |  | 570196 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 670423 | 8266 | 3 |  |  |  | 12 | 460412 | new | 460412 | Bedok North Ave 2 | 10-1pm |  | 32 | new | 12
189673 |  |  | 6 |  |  |  | 289850 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 189673 | 8591 | 4 |  |  |  | 4 | 460412 | what if | 460412 | Bedok North Ave 2 | 10-1pm |  | 33 | what if | 4
018989 |  |  | 6 |  |  |  | 670236 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 18989 | 8471 | 6 |  |  |  | 6 | 510637 | 1737 | 510637 | [NAME] | 10-1pm |  | 34 | 1737 | 6
068898 |  |  | 6 |  |  |  | 670423 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 68898 | 8470 | 8 |  |  |  | 7 | 510637 | 1737 | 510637 | [NAME] | 10-1pm |  | 35 | 1737 | 7
068898 |  |  | 6 |  |  |  | 596780 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 68898 | new2 | 1 |  |  |  | 10 | 530952 | 1950 | 530952 | [NAME] 9 | 10-1pm |  | 36 | 1950 | 10
408934 |  |  | 7 |  |  |  | 640458 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 408934 | 8468 | 13 |  |  |  | 4 | 49246 | 8587 | 49246 | [NAME] | 10-1pm |  | 37 | 8587 | 4
128476 |  |  | 7 |  |  |  | 640518 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 128476 | yyy | 3 |  |  |  | 10 | 90037 |  | 90037 | Telok Blangah Rise | 10-1pm | after 1145am | 38 |  | 10
568402 |  |  | 7 |  |  |  | 649848 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 568402 | yyy | 2 |  |  |  | 1 | 750422 | xxx | 750422 | Canberra Road | 2-5pm |  | 39 | xxx | 1
570196 |  |  | 7 |  |  |  | 640977 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 570196 | yyy | 3 |  |  |  | 1 | 750422 | xxx | 750422 | Canberra Road | 2-5pm |  | 40 | xxx | 1
439204 |  |  | 7 |  |  |  | 641989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 439204 | yyy | 4 |  |  |  | 3 | 670423 | 8266 | 670423 | Fajar Road | 2-5pm |  | 41 | 8266 | 3
596780 |  |  | 7 |  |  |  | 120118 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 596780 | yyy | 5 |  |  |  | 2 | 189673 | 8591 | 189673 | Beach Road | 2-5pm |  | 42 | 8591 | 2
543180 |  |  | 8 |  |  |  | 128476 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 543180 | zz | 1 |  |  |  | 1 | 189673 | 8591 | 189673 | Beach Road | 2-5pm |  | 43 | 8591 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 189673 | 8591 | 189673 | Beach Road | 2-5pm |  | 44 | 8591 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 18989 | 8471 | 18989 | One Marina Blvd | 2-5pm |  | 45 | 8471 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 68898 | 8470 | 68898 | Robinson Road | 2-5pm |  | 46 | 8470 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 68898 | new2 | 68898 | Robinson Road | 2-5pm |  | 47 | new2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 408934 | 8468 | 408934 | Ubi Avenue 1 | 2-4pm | try before 4pm | 48 | 8468 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 408934 | 8468 | 408934 | Ubi Avenue 1 | 2-4pm | try before 4pm | 49 | 8468 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 128476 | yyy | 128476 | Pandan Crescent |  |  | 51 | yyy | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 568402 | yyy | 568402 | [NAME] |  |  | 52 | yyy | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 570196 | yyy | 570196 | [NAME] |  |  | 53 | yyy | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 439204 | yyy | 439204 | [NAME] |  |  | 54 | yyy | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 596780 | yyy | 596780 | East Coast |  |  | 55 | yyy | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 543180 | zz | 543180 | [NAME] |  |  | 57 | zz | 1