Spreadsheet: 745376d1629890932-sum-if-vlookup-matches-criteria-copy-of-raw-data
Sheet: Veh_List

Fleet Number | Licence Plate | Vehicle Type | Model
MT-01 | BCB-3633 | VOLVO
MT-02 | BCA-324 | FREIGHTLINER
MT-03 | BCA-323 | FREIGHTLINER
MT-04 | ABZ-6791 | FREIGHTLINER
MT-05 | ABZ-6792 | FREIGHTLINER
MT-06 | ACP-856 | FREIGHTLINER
MT-07 | ACP-857 | FREIGHTLINER
MT-08 | BCB-3275 | FREIGHTLINER
MT-09 | [NAME] | FREIGHTLINER
MT-10 | BCD2618 | FREIGHTLINER
MT-11 | ACP-855 | FREIGHTLINER
MT-12 | ACP-860 | FREIGHTLINER
[NAME] | ACP-6642 | FREIGHTLINER
MT-14 | ACR-4008 | FREIGHTLINER
MT-15 | ACR-4022 | FREIGHTLINER
MT-16 | ACR-4023 | FREIGHTLINER
MT-17 | ACL-5826 | IVECO
MT-18 | ACL-5651 | IVECO
MT-19 | ACL-5654 | IVECO
MT-21 | BCA-325 | FREIGHTLINER
MT-22 | BCA-4099 | FREIGHTLINER
MT-23 | BCB-7671 | VOLVO
MT-24 | BCA-4098 | FREIGHTLINER
MT-25 | BCA-5814 | FREIGHTLINER
MT-27 | BCA-5813 | VOLVO
MT-28 | BCA-5812 | FREIGHTLINER
MT-29 | BCA-5505 | IVECO
MT-30 | ACG-6833 | BENZ
MT-31 | BCA-8015 | FREIGHTLINER
MT-32 | BCA-8012 | FREIGHTLINER
MT-33 | BCA-8013 | FREIGHTLINER
MT-34 | [NAME] | FREIGHTLINER
MT-35 | ACZ-2360 | VOLVO
MT-36 | BCB-6738 | VOLVO
MT-37 | BCA-8867 | FREIGHTLINER
MT-38 | BCA-8873 | FREIGHTLINER
[NAME] | BCB-3053 | VOLVO
MT-40 | BCB-3054 | VOLVO
MT-41 | BCB-3056 | VOLVO
MT-42 | BCB-3636 | VOLVO
MT-43 | BCB-3334 | VOLVO
MT-44 | BCB-4922 | VOLVO
MT-45 | BCB-4925 | VOLVO
MT-46 | BCB-4926 | VOLVO
MT-47 | BCB-4927 | VOLVO
MT-48 | AAJ-8882 | IVECO
MT-49 | BCB-6737 | VOLVO
MT-50 | BCB-6739 | VOLVO
MT-51 | BCB-6740 | VOLVO
MT-52 | BCB-6963 | VOLVO
MT-53 | BCB-6964 | VOLVO
MT-54 | BCB-6965 | VOLVO
MT-55 | [NAME] | VOLVO
MT-56 | BCB-7668 | VOLVO
MT-57 | BCB-7669 | VOLVO
MT-58 | BCB-7670 | VOLVO
MT-59 | BCB-7874 | VOLVO
MT-60 | BCB-7876 | VOLVO
[NAME] | BCB-8404 | VOLVO
MT-62 | BCB-8408 | VOLVO
MT-63 | BCB-8409 | VOLVO
MT-64 | BCB-8643 | VOLVO
MT-65 | BCB-8784 | VOLVO
MT-66 | BCC-955 | VOLVO
MT-67 | BCC-789 | VOLVO
MT-68 | BCC-1745 | VOLVO
MT-69 | BCC-1904 | VOLVO
[NAME] | BCC-2812 | VOLVO
MT-71 | BCB-3254 | VOLVO
MT-72 | BCC-3678 | VOLVO
MT-73 | [NAME] | VOLVO
MT-74 | BCC5574 | VOLVO
MT-75 | BCC5575 | VOLVO
[NAME] | BCC5921 | VOLVO
[NAME] | BCC5922 | VOLVO
MT-78 | BCC6457 | VOLVO
MT-79 | BCC 7187 | VOLVO
MT-80 | BCC7188 | VOLVO
MT-81 | BCC7343 | VOLVO
[NAME] | BCC 7189 | VOLVO
MT-83 | BCC 7252 | VOLVO
MT-84 | BCD 643 | VOLVO
MT-85 | BCD 1481 | VOLVO
MT-86 | BCD 2276 | VOLVO
MT-87 | AJE 3977 | VOLVO
MT-88 | AJE 4182 | VOLVO
MT-89 | ACX 7637 | VOLVO
MT-90 | BCD 6081 | VOLVO
MT-91 |  | VOLVO
TATA | ACZ-6179 | TATA
Bonano 1 | BCC-438 | BONANO
[NAME] | BCC-345 | BONANO
Bonano 3 | BCC123 | BONANO
[NAME] | AJD-8457 | BONANO
[NAME]'s truck | BCC-971 | FREIGHTLINER
Ready mix 01 | BCB-4774 | ASTRA
Ready mix 02 | BCB4779 | ASTRA
Ready mix 03 | BCB-4772 | ASTRA
Ready mix 04 | BCB-4773 | ASTRA
Ready mix 05 | BCB-4775 | ASTRA
Ready mix 06 | BCB-4778 | ASTRA
Ready mix 07 | BCB-5228 | ASTRA
LD 01 | Loader 01 | EARTHMOVING
LD 02 | Loader 02 | EARTHMOVING
LD 03 | Loader 03 | EARTHMOVING
LD 04 | Loader 04 | EARTHMOVING
LD 05 | Loader 05 | EARTHMOVING
LD 06 | Loader 06 | EARTHMOVING
LD 07 | Loader 07 | EARTHMOVING
LD 08 | Loader 08 | EARTHMOVING
LD 09 | Loader 09 | EARTHMOVING
DT-725 | DUMPER 725 | EARTHMOVING |  | DT-725
DT-730-09 | DUMPER 730-09 | EARTHMOVING |  | DT-730-09
DT-730-10 | DUMPER 730-10 | EARTHMOVING |  | DT-730-10
DT-730-11 | DUMPER 740-1 | EARTHMOVING |  | DT-730-11
DT-730-12 | DUMPER 740-2 | EARTHMOVING |  | DT-730-12
DT-730-13 | DUMPER 740-3 | EARTHMOVING |  | DT-730-13
DT-730-14 | DUMPER 740-4 | EARTHMOVING |  | DT-730-14
DT-730-15 | DUMPER 740-5 | EARTHMOVING |  | DT-730-15
DT-730-16 | DUMPER 740-6 | EARTHMOVING |  | DT-730-16
DT-730-17 | DUMPER 740-7 | EARTHMOVING |  | DT-730-17
DT-730-18 | DUMPER 740-8 | EARTHMOVING |  | DT-730-18
DT-730-19 | DUMPER 740-9 | EARTHMOVING |  | DT-730-19
DT-730-20 | DUMPER 740-10 | EARTHMOVING |  | DT-730-20
DT-730-21 | DUMPER 740-11 | EARTHMOVING |  | DT-730-21
DT-730-22 | DUMPER 740-12 | EARTHMOVING |  | DT-730-22
EX-345 | EX-345 Shovel | EARTHMOVING |  | EX-345
EX-374 | EX-374 Shovel | EARTHMOVING |  | EX-374
EX-365 | EX-365 Shovel | EARTHMOVING |  | EX-365
CRANE-18 | CRANE-18 | EARTHMOVING |  | CRANE-18
CRANE-19 | CRANE-19 | EARTHMOVING |  | CRANE-19
CRANE-20 | CRANE-20 | EARTHMOVING |  | CRANE-20
CRANE-21 | CRANE-21 | EARTHMOVING |  | CRANE-21
GRADER 140k | GRADER 140k | EARTHMOVING |  | GRADER 140k
GRADER-2 | GRADER-2 | EARTHMOVING |  | GRADER-2
TELESCOPIC | TELESCOPIC | EARTHMOVING |  | TELESCOPIC
COMPACTOR | COMPACTOR | EARTHMOVING |  | COMPACTOR
D6 | D6 Dozer | EARTHMOVING |  | D6
D8 | D8 Dozer | EARTHMOVING |  | D8
Lighting Set | Lighting Set | EARTHMOVING |  | Lighting Set
DRILL 14 | Drill-14 | EARTHMOVING |  | DRILL 14
DRILL 04 | Drill-04 | EARTHMOVING |  | DRILL 04
Small W.Bower |  | EARTHMOVING
W.BOWSER-740 | WB-740 | EARTHMOVING
D.BOWSER |  | EARTHMOVING
[NAME] |  | EARTHMOVING
ALZ-8497 | [NAME] | OTHER VEHICLES
ABZ-6320 | Mobile-Mubanga | OTHER VEHICLES
ALT-559 | [NAME] | OTHER VEHICLES
ALR-6422 | [NAME] | OTHER VEHICLES
BCB-7011 | Mobile | OTHER VEHICLES
BAA-2622 | Sales | OTHER VEHICLES
AJD9474 | [NAME]) | OTHER VEHICLES
BCC-326 | Prince ([NAME].) | OTHER VEHICLES
BAA-2877 | [NAME] (Admn.) | OTHER VEHICLES
ACZ-9514 | Admn. | OTHER VEHICLES
BCA-6789 | Admin. | OTHER VEHICLES
ABZ-1037 | Green (Admn.) | OTHER VEHICLES
ALT-3610 | Chama | OTHER VEHICLES
ALD-1765 | [NAME] | OTHER VEHICLES
BCB7308 | [NAME] ([NAME].) | OTHER VEHICLES
DG@TD's Resi | Admin. | OTHER VEHICLES
ALX 3500 | [NAME] (Chama) | OTHER VEHICLES
BCC-825 | Shanthi Reddy | OTHER VEHICLES
ABP-2645 | [NAME] | OTHER VEHICLES
ALD-8552 | Sales | OTHER VEHICLES
BAA-2636 | Sales | OTHER VEHICLES
BAA2876 | Collings | OTHER VEHICLES
BAD6040 | [NAME] | OTHER VEHICLES
ALT-3150 | GM | OTHER VEHICLES
[NAME] | Mr.[NAME] | OTHER VEHICLES
BAA-8316 | [NAME] (Mine) | OTHER VEHICLES
BAA-8651 | Bhagwan(Mech.) | OTHER VEHICLES
BCB-6132 | Ramaraju | OTHER VEHICLES
ALR-9283 | [NAME] | OTHER VEHICLES
BCD-2619 | Mobile | OTHER VEHICLES
BAA-2620 | Ranjith | OTHER VEHICLES
[NAME] | Kafwimbi (Mobil) | OTHER VEHICLES
ABK9043 | Rajender (Fabri.) | OTHER VEHICLES
BAA-5765 | Zlajie | OTHER VEHICLES
AAK3988 | Godfrey (Trpt.) | OTHER VEHICLES
ACX 8329 | Godfrey (Trpt.) | OTHER VEHICLES
ABM-9714 | Situmbeko | OTHER VEHICLES
BAA-8649 | Sales | OTHER VEHICLES
ALB-8849 | rasta | OTHER VEHICLES
AAB-7673 | Hunting Truck | OTHER VEHICLES
ABX- 5819 | [NAME] (DB) | OTHER VEHICLES
ACG-5625 | Hired truck | OTHER VEHICLES
BCC-1904 | [NAME] | OTHER VEHICLES
[NAME] LIFT-1 | Mobile | OTHER VEHICLES
[NAME] LIFT-2 | Mobile | OTHER VEHICLES
[NAME] LIFT-3 | Mobile | OTHER VEHICLES
[NAME] LIFT-4 | Mobile | OTHER VEHICLES
FORk Lift- CAT | Mobile | OTHER VEHICLES
ALC-116  Tractor | Civil/HR | OTHER VEHICLES
DG@MD's Resi. | Admn. | OTHER VEHICLES
[NAME] | Admn. | OTHER VEHICLES
[NAME] | Admn. | OTHER VEHICLES
[NAME] | Admn. | OTHER VEHICLES
Plant DG set | Elect., | OTHER VEHICLES
[NAME] | Admin. | OTHER VEHICLES
Prince's Gen-set | [NAME] | OTHER VEHICLES
julius's [NAME] | [NAME] | OTHER VEHICLES
[NAME]'s Flats | [NAME] | OTHER VEHICLES
ASTREA | Ndola | OTHER VEHICLES
Ambulance | Admin. | OTHER VEHICLES
GeneralMisellaneous | Others | OTHER VEHICLES
BAC 6789 | GOMELI | OTHER VEHICLES
BAJ 8910 | GOMELI | OTHER VEHICLES
ARL 4422 | GOMELI | OTHER VEHICLES
BAE6956 | MAMBWE | OTHER VEHICLES
MOSA DG set | Fabrication | OTHER VEHICLES
ACC 3688 | [NAME] | OTHER VEHICLES
ACC2004 | [NAME] | OTHER VEHICLES
BCC-8610 | WS | OTHER VEHICLES
ABH 7490 | Jhonas | OTHER VEHICLES
ZP235913 | POLICE PLNT | OTHER VEHICLES
BCA-6654 | [NAME] | OTHER VEHICLES
Coster bus-1 | BCB-8244 | BUSES
Coster bus-2 | BCB-8639 | BUSES
Coster bus-4 | BCB-8638 | BUSES
Coster bus-3 | BCB-8243 | BUSES
Inter-bus | BCA-9016 | BUSES
Inter-bus | BCA-9480 | BUSES
Inter-bus | BCA-9017 | BUSES
Bus 5 | ACT-1279 | BUSES
CCR Van | BCB-7092 | BUSES
Silicosis | BCC-8046 | BUSES
team [NAME] | ACT-3756 | BUSES