Spreadsheet: 99242d1297947710-vlookup-not-working-dispatches
Sheet: DISPATCHES

ATC | DATE | WAY BILL NO | TRUCK NUMBER | DEPOT ATC NO. | VALIDATION CODE | REFERENCE NO. | DEPOT INVOICE NO. | DELIVERY QTY/BAGS | DELIVERY QTY/TONS | DELIVERY AMOUNT. | CUSTOMER NAME | COMMENT/REMARK
11000598 | 2011-01-02 00:00:00 | 1698 | XB   589   KWU |  |  |  | 164 | 600 | 30 | 810000 | [NAME] | OK
11000624 | 2011-01-02 00:00:00 | 1771 | XU   984   AGL |  |  |  | 173 | 600 | 30 | 810000 | EMEKA UNACHUKWU | OK
11000433 | 2011-01-02 00:00:00 | 1885 | XA   739   GWK |  |  |  | 175 | 600 | 30 | 810000 | GEOFFREY | OK
11000724 | 2011-01-02 00:00:00 | 1890 | XN   668   KRD |  |  |  | 174 | 600 | 30 | 810000 | ALBERT ILO | OK
11000397 | 2011-01-02 00:00:00 | 1487 | XS   329   GGE |  |  |  | 186 | 600 | 30 | 810000 | PIUS UCHE | OK
11000619 | 2011-01-02 00:00:00 |  | XA   882   GWK |  |  |  | 161 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000586 | 2011-01-02 00:00:00 | 1743 | XA   885   GWK |  |  |  | 162 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000430 | 2011-01-02 00:00:00 | 1881 | XA   894   GWK |  |  |  | 163 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000594 | 2011-01-02 00:00:00 |  | XB   182   KGE |  |  |  | 189 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000585 | 2011-01-02 00:00:00 | 1746 | XA   805   GWK |  |  |  | 165 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000591 | 2011-01-02 00:00:00 |  | XA   809   GWK |  |  |  | 170 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000620 | 2011-01-02 00:00:00 | 1969 | XA   900   GWK |  |  |  | 187 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000599 | 2011-01-02 00:00:00 |  | XT   833   LND |  |  |  | 171 | 600 | 30 | 810000 | IFEANYI EBO | OK
11000583 | 2011-01-02 00:00:00 |  | XA   887   GWK |  |  |  | 177 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11000595 | 2011-01-02 00:00:00 |  | XA   878   GWK |  |  |  | 178 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11000589 | 2011-01-02 00:00:00 |  | XA   891  GWK |  |  |  | 184 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11000590 | 2011-01-02 00:00:00 |  | XA   803   GWK |  |  |  | 181 | 600 | 30 | 810000 | MBAEKWE OLISA | OK
11000431 | 2011-01-02 00:00:00 | 1886 | XA   800   GWK |  |  |  | 166 | 600 | 30 | 810000 | INNO - ABATETE | OK
11000592 | 2011-01-02 00:00:00 |  | XA   898   GWK |  |  |  | 179 | 600 | 30 | 810000 | [NAME] | OK
11000725 | 2011-01-02 00:00:00 | 1874 | XA   888   GWK |  |  |  | 176 | 600 | 30 | 810000 | TESSY OBI NIG LTD | OK
11000622 | 2011-01-02 00:00:00 | 1788 | XR   699   BDG |  |  |  | 182 | 600 | 30 | 810000 | TESSY OBI NIG LTD | OK
11000623 | 2011-01-02 00:00:00 | 1772 | XT   549   SMK |  |  |  | 172 | 600 | 30 | 810000 | TESIBE CEMENT SHOP | OK
11000588 | 2011-01-02 00:00:00 |  | XZ   480   ENU |  |  |  | 180 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000432 | 2011-01-02 00:00:00 | 1880 | XA   735   GWK |  |  |  | 188 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000723 | 2011-01-02 00:00:00 |  | XA   880   GWK |  |  |  | 190 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000621 | 2011-01-02 00:00:00 | 1785 | XV   685   AGL |  |  |  | 167 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000597 | 2011-01-02 00:00:00 | 1696 | XQ   535   BDG |  |  |  | 168 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000593 | 2011-01-02 00:00:00 |  | XA   896   GWK |  |  |  | 169 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000618 | 2011-01-02 00:00:00 | 1859 | XA   736   GWK |  |  |  | 183 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000400 | 2011-01-02 00:00:00 | 1456 | XV   811   AGL |  |  |  | 185 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000616 | 2011-02-02 00:00:00 | 1981 | XA   584   GWK |  |  |  | 198 | 600 | 30 | 810000 | CHUKWUDI EZE | OK
11000615 | 2011-02-02 00:00:00 | 1971 | XA   769   GWK |  |  |  | 193 | 600 | 30 | 810000 | EBO GREG | OK
11000726 | 2011-02-02 00:00:00 | 13062 | XU   984   AGL |  |  |  | 196 | 600 | 30 | 810000 | IFEANYI EBO | OK
11000733 | 2011-02-02 00:00:00 | 13060 | XT   402   LND |  |  |  | 194 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11000617 | 2011-02-02 00:00:00 | 2060 | XA   765   GWK |  |  |  | 195 | 600 | 30 | 810000 | COL. [NAME] | OK
11000596 | 2011-02-02 00:00:00 |  | XA   889   GWK |  |  |  | 197 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000626 | 2011-03-02 00:00:00 | 2057 | XU    62  AGL |  |  |  | 261 | 600 | 30 | 810000 | [NAME] | OK
11001576 | 2011-03-02 00:00:00 | 13111 | XA   871   GWK |  |  |  | 252 | 600 | 30 | 810000 | GEOFFREY | OK
11000732 | 2011-03-02 00:00:00 | 13055 | XY   607  APP |  |  |  | 256 | 600 | 30 | 810000 | GEOFFREY | OK
11000731 | 2011-03-02 00:00:00 | 2050 | KW   703   FKJ |  |  |  | 258 | 600 | 30 | 810000 | ALBERT ILO | OK
11000728 | 2011-03-02 00:00:00 | 13067 | XR   699   BDG |  |  |  | 199 | 600 | 30 | 810000 | OGA LAW | OK
11000627 | 2011-03-02 00:00:00 | 2077 | XX   196   MUS |  |  |  | 260 | 600 | 30 | 810000 | EBO GREG | OK
11000737 | 2011-03-02 00:00:00 | 13123 | XA   735   GWK |  |  |  | 257 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000740 | 2011-03-02 00:00:00 | 13100 | XA   886   GWK |  |  |  | 200 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000616 | 2011-03-02 00:00:00 | 2100 | XA   894   GWK |  |  |  | 255 | 600 | 30 | 810000 | IFEANYI EBO | OK
11001578 | 2011-03-02 00:00:00 | 13108 | XA   887   GWK |  |  |  | 253 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11000729 | 2011-03-02 00:00:00 | 3068 | XT   549   SMK |  |  |  | 259 | 600 | 30 | 810000 | [NAME] | OK
11000730 | 2011-03-02 00:00:00 | 2040 | XV   811   AGL |  |  |  | 251 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000734 | 2011-03-02 00:00:00 | 13106 | XA   891   GWK |  |  |  | 254 | 600 | 30 | 810000 | MAMAIKOLO VERONICA IFEOMA | OK
11000739 | 2011-04-02 00:00:00 | 2154 | XA   739   GWK |  |  |  | 266 | 600 | 30 | 810000 | [NAME] | OK
11000841 | 2011-04-02 00:00:00 | 2257 | XX   196   MUS |  |  |  | 263 | 600 | 30 | 810000 | EMEKA UNACHUKWU | OK
11000735 | 2011-04-02 00:00:00 | 2167 | XA   886   GWK |  |  |  | 264 | 600 | 30 | 810000 | EBO GREG | OK
11000736 | 2011-04-02 00:00:00 | 2212 | XA   883   GWK |  |  |  | 267 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000738 | 2011-04-02 00:00:00 | 2159 | XA   736   GWK |  |  |  | 265 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000625 | 2011-04-01 00:00:00 | 2043 | XV   685   AGL |  |  |  | 262 | 600 | 30 | 810000 | [NAME] | OK
11000742 | 2011-05-02 00:00:00 | 13277 | XR   699   BDG |  |  |  | 269 | 600 | 30 | 810000 | [NAME] | OK
11000839 | 2011-05-02 00:00:00 | 13239 | XT   549   SMK |  |  |  | 268 | 600 | 30 | 810000 | GEOFFREY | OK
11000742 | 2011-05-02 00:00:00 | 2357 | XY   607   APP |  |  |  |  | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000842 | 2011-05-02 00:00:00 | 2268 | XR   700   BDG |  |  |  | 271 | 600 | 30 | 810000 | BEDE OBIAKO | OK
11000843 | 2011-05-02 00:00:00 | 13249 | XW   703   FKJ |  |  |  |  | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000863 | 2011-07-02 00:00:00 | 20531 | XZ   480   ENU |  |  |  | 277 | 600 | 30 | 810000 | GEOFFREY | OK
11000857 | 2011-07-02 00:00:00 |  | XA   899   GWK |  |  |  | 274 | 600 | 30 | 810000 | EBO GREG | OK
11000847 | 2011-07-02 00:00:00 | 20568 | XA   809   GWK |  |  |  | 280 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000851 | 2011-07-02 00:00:00 | 20654 | XA   891   GWK |  |  |  | 276 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11000850 | 2011-07-02 00:00:00 |  | XA   887   GWK |  |  |  | 273 | 600 | 30 | 810000 | IFEANYI EBO | OK
11000853 | 2011-07-02 00:00:00 | 20534 | XA   736   GWK |  |  |  | 279 | 600 | 30 | 810000 | TESSY OBI NIG LTD | OK
11000844 | 2011-07-02 00:00:00 | 20580 | XA   897   GWK |  |  |  | 275 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000856 | 2011-07-02 00:00:00 | 20530 | XA   735   GWK |  |  |  | 278 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11001000 | 2011-08-02 00:00:00 | 20716 | XV   811   AGL |  |  |  | 281 | 600 | 30 | 810000 | [NAME] | OK
11000845 | 2011-08-02 00:00:00 | 2474 | XA   766   GWK |  |  |  | 282 | 600 | 30 | 810000 | [NAME] | OK
11000866 | 2011-08-02 00:00:00 | 20708 | XT   549   SMK |  |  |  | 284 | 600 | 30 | 810000 | DAME MARIA AGUKWENDU | OK
11000867 | 2011-08-02 00:00:00 | 20710 | XR   699   BDG |  |  |  | 289 | 600 | 30 | 810000 | EBO GREG | OK
11000860 | 2011-08-02 00:00:00 | 20647 | XA   892   GWK |  |  |  | 287 | 598 | 29.9 | 807300 | LOTANNA | Shortage of 2 bags
11000859 | 2011-08-02 00:00:00 |  | XA   884   GWK |  |  |  | 283 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11000868 | 2011-08-02 00:00:00 | 20707 | XY   607   APP |  |  |  | 288 | 600 | 30 | 810000 | IFEANYI EBO | OK
11001003 | 2011-08-02 00:00:00 | 20739 | XT   402   LND |  |  |  | 286 | 600 | 30 | 810000 | MRS. GRACE OGBONNA | OK
11000865 | 2011-08-02 00:00:00 | 20699 | XW   703   FKJ |  |  |  | 285 | 600 | 30 | 810000 | MAMAIKOLO VERONICA IFEOMA | OK
11000743 | 2011-08-02 00:00:00 | 20503 | XV   685   AGL |  |  |  | 290 | 600 | 30 | 810000 | [NAME] | OK
11001011 | 2011-09-02 00:00:00 | 13440 | XA   895   GWK |  |  |  | 293 | 600 | 30 | 810000 | GEOFFREY | OK
11000857 | 2011-09-02 00:00:00 |  | XA   899   GWK |  |  |  | 292 | 600 | 30 | 810000 | EBO GREG | OK
11000849 | 2011-09-02 00:00:00 | 20543 | XA   886   GWK |  |  |  | 295 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
1101010 | 2011-09-02 00:00:00 | 13415 | XA   735   GWK |  |  |  | 296 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11001005 | 2011-09-02 00:00:00 | 13420 | XA   526   GWK |  |  |  | 297 | 600 | 30 | 810000 | CHIDI.C. EKEDUM | OK
11001008 | 2011-09-02 00:00:00 | 13414 | XA   882   GWK |  |  |  | 201 | 600 | 30 | 810000 | PAUL ENDWELL NIG LTD | OK
11001006 | 2011-09-02 00:00:00 | 13426 | XA   800   GWK |  |  |  | 203 | 600 | 30 | 810000 | BEDE OBIAKO | OK
11000854 | 2011-09-02 00:00:00 | 20602 | XA   739   GWK |  |  |  | 294 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000852 | 2011-09-02 00:00:00 | 20633 | XA   584   GWK |  |  |  | 299 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11000846 | 2011-09-02 00:00:00 | 20590 | XA   876   GWK |  |  |  | 300 | 600 | 30 | 810000 | OZUMBA SUNDAY | OK
11001013 | 2011-09-02 00:00:00 | 13431 | XA   896   GWK |  |  |  | 298 | 600 | 30 | 810000 | C.U IBEKE | OK
11000862 | 2011-09-02 00:00:00 | 20538 | XA   882   GWK |  |  |  | 202 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11001001 | 2011-09-02 00:00:00 | 20770 | XV   685   AGL |  |  |  | 204 | 600 | 30 | 810000 | [NAME] | OK
11001002 | 2011-11-02 00:00:00 | 20717 | XX   703   FKJ |  |  |  | 209 | 600 | 30 | 810000 | EBO GREG | OK
11001012 | 2011-11-02 00:00:00 | 13418 | XA   733   GWK |  |  |  | 206 | 600 | 30 | 810000 | UMENZE NIG CO. | OK
11001009 | 2011-11-02 00:00:00 | 13408 | XA   890   GWK |  |  |  | 205 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000840 | 2011-11-02 00:00:00 | 13312 | XV   811   AGL |  |  |  | 207 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11001007 | 2011-11-02 00:00:00 | 13427 | XA   769   GWK |  |  |  | 208 | 600 | 30 | 810000 | DOMMY MORRIS | OK
11000848 | 2011-11-02 00:00:00 | 20541 | XA   890   GWK |  |  |  | 210 | 600 | 30 | 810000 | DOMMY MORRIS | OK