Spreadsheet: 473644d1470317503-matching-up-vin-numbers-from-two-different-worksheets-vlookup-book2
Sheet: Sheet1

 |  |  |  | AUTOMOBILE SCHEDULE
No. | Year | Make | Model | Vin No. | Class Codes | Territory | Cost New | GVW | Comprehensive Deductible | Collision Deductible
1 | 2012 | Chevrolet | 1500 RE | 1GCNCPEX1CZ321685 | 1499 |  | 17548 |  | 1000 | 1000
2 | 1994 | Ford F-700 | WS24 | 1FDXK74CORVA25353 | 31499 |  | 34417 |  | 1000
3 | 1996 | Ford F-800 | WS27 | 1FDXF80E1TVA27542 | 31499 |  | 39600 |  | 1000
4 | 1999 | Ford F-250 Pickup | WS37 | 1FTNF20F2XEB82995 | 1499 |  | 23750 |  | 1000
5 | 1999 | Hooper | Dump Trailer | 4TOFB2523X1005725 | 68479 |  | 9000
6 | 2001 | Ford F-250 Pickup | WS46 | 1FTNF20F91EC19273 | 1499 |  | 22900 |  | 1000
7 | 2012 | CHEVROLET | 1500RE | 1GCNCPEX9CZ141225 | 1499 |  | 15458 |  | 1000 | 1000
8 | 2001 | Ford F-450 | WS50 | 1FDXW46F71EC83190 | 21499 |  | 37264 |  | 1000
9 | 2002 | Ford F-150 Pickup | WS51 | 1FTRF17W02NB39248 | 1499 |  | 15986 |  | 1000
10 | 2002 | Ford F-150 Pickup | WS52 | 1FTRF17W22NB39249 | 1499 |  | 15986 |  | 1000
11 | 2003 | Ford F-150 Pickup | WS302 | 2FTRX18W63CB12896 | 1499 |  | 20868 |  | 1000
12 | 2002 | Ford F-150 Pickup | [NAME] | 1FTRX18L92NB39251 | 1499 |  | 21458 |  | 1000
13 | 2005 | Ford F-150 Pickup | [NAME] | 1FTRF12WX5NB43996 | 1499 |  | 14122 |  | 1000 | 1000
14 | 2005 | Ford F-250 Pickup | WS503 | 1FTSW21P25ED17061 | 1499 |  | 25199 |  | 1000 | 1000
15 | 2006 | Ford F-150 Pickup | [NAME] | 1FTRX12W46FB09187 | 1499 |  | 16212 |  | 1000 | 1000
16 | 2006 | Ford F-250 Pickup | WS604 | 1FTSW21P06ED42588 | 1499 |  | 26877 |  | 1000 | 1000
17 | 2006 | Ford F-350 Pickup | WS606 | 1FTWW33P36ED42590 | 1499 |  | 27700 |  | 1000 | 1000
18 | 2006 | Ford F-350 Pickup | WS605 | 1FDWW37PX6ED42589 | 1499 |  | 26436 |  | 1000 | 1000 | Deleted 8-24-15
19 | 2006 | Ford F-150 Pickup | WS607 | 1FTSF20P06ED35111 | 1499 |  | 19508 |  | 1000 | 1000
20 | 2007 | Ford F-350 Dump | WS701 | 1FDWW37Y18EA14943 | 1499 |  | 36952 |  | 1000 | 1000
21 | 2008 | International | 4400 | 1HTMKAAN88H649282 | 31499 |  | 60359 |  | 1000 | 1000
22 | 2007 | Haulass | [NAME] | 5JYLB35237P071392 | 69499 |  | 10000
23 | 2006 | Gooseneck | Trailer | 1T9GF20256L847043 | 69499 |  | 6390
24 | 2007 | Chevy Van Express | [NAME] (WS5501) | 1GCGG25V171145501 | 1499 |  | 16400 |  | 1000 | 1000
25 | 2009 | Chevy Colorado | WS802 | 1GCCS19E098104269 | 1499 |  | 18109 |  | 1000 | 1000
26 | 2009 | [NAME] | WS803 | 1FTYRI4E39PA23815 | 1499 |  | 13467 |  | 1000 | 1000
27 | 2006 | [NAME] | WE4622 | 1R97312176P195012 | 69499 |  | 7800
28 | 2009 | Hooper | Flatbed | 4T0FB061991000834 | 69499 |  | 550
29 | 2004 | Hooper | Trailer | 4TOFB162741004937 | 69499 |  | 10000
30 | 2003 | [NAME] | GV54464 | 4TOFB081531004674 | 69499 |  | 10000
31 | 2005 | [NAME] | GV54586 | 4TOFB252551002998 | 69499 |  | 10000
32 | 2009 | Ranger | [NAME] | IFTYR14E69PA51477 | 1499 |  | 15118 |  | 1000 | 1000
33 | 2005 | [NAME] | GV54590 | 4TOFB252951003734 | 69499 |  | 10000
34 | 2000 | GMC Yellow Dump | Dump Truck | 4V2JCBMD5MR811814 | 23479 |  | 30000 |  | 1000 | 1000
35 | 2007 | Carry On 16x12 | Enclosed Trailer | 4YMCL12147G084287 | 69499 |  | 2200
36 | 1991 | AM General | Dump Truck | 2900791 | 23479 |  | 30000 |  | 1000 | 1000
37 | 2011 | Ford | Ranger | 1FTKR1ED9BPA48462 | 1499 |  | 18000 |  | 1000 | 1000
38 | 2011 | GMC | Sierra | 3 GTP 2 WE3 7B G254821 | 1499 |  | 45100 |  | 1000 | 1000
39 | 2012 | Chevy 1500 | WS1102 | 1GCRCPEX9CZ109523 | 1499 |  | 26340 |  | 1000 | 1000
40 | 2012 | Chevy 1500 | WS1103 | 1GCRCPEX6CZ109771 | 1499 |  | 26340 |  | 1000 | 1000 | Deleted 10-6-15
41 | 2012 | Chevy 2500 | WS1104 | 1GB0CVCG7CF115701 | 1499 |  | 28800 |  | 1000 | 1000
42 | 2012 | Chevy 2500 | WS1105 | 1GB0CVCG1CF115354 | 1499 |  | 28800 |  | 1000 | 1000
43 | 2012 | GMC 3500Crew | . | 1GT422C80CF167761 | 1499 |  | 41385 |  | 1000 | 1000
44 | 2008 | Freightliner | . | 1FVXAU00X8PZ73624 | 1499 |  | 35000 |  | 1000 | 1000
45 | 2003 | Ford F350 | . | 1FDSW30L43EC95979 | 1499 |  | 6500 |  | 1000 | 1000
46 | 2012 | Chevrolet | 1500 | 1GCRKPRA3CZ351786 | 1499 |  | 31236 |  | 1000 | 1000
47 | 2003 | Ford | F-450 | 1FDXX47P43EC95742 | 21499 |  | 30000 |  | 1000
48 | 2003 | Ford | F-450 | 1FDXX47P43EC95739 | 21499 |  | 30000 |  | 1000
49 | 2013 | Chevrolet | 1500 | 1GCNCPEXXDZ235521 | 1499 |  | 19385 |  | 1000 | 1000
50 | 2013 | Chevrolet | 1500 | 1GCNCPEX9DZ384387 | 1499 |  | 19385 |  | 1000 | 1000
51 | 2013 | Chevrolet | 3500 | 1GD422C88DF208392 | 1499 |  | 47690 |  | 1000 | 1000
52 | 2013 | Chevrolet | 1500 | 1GCNCPEX5DZ264778 | 1499 |  | 19385 |  | 1000 | 1000
53 | 2013 | Chevrolet | 1500 | 1GTN1TEX5DZ170088 | 1499 |  | 19385 |  | 1000 | 1000
54 | 2013 | Ford | F150 | 1ftfw1ef2dfd70185 | 1499 |  | 21222 |  | 1000 | 1000
55 | 2014 | Chevrolet | Silverado | 1GB4KZC85EF139244 | 1499 |  | 65286 |  | 1000 | 1000
56 | 2014 | Ford | F-450 Sewer Jetter | 1FDUF5HT3EEB53229 | 1499 |  | 99650 |  | 1000 | 1000
57 | 2013 | HOOPER 7X20 TRAILER | WE1167 | 4TOFB2024D1001167 | 68499
58 | 2012 | BETTER BUILT 8 TON | WE1437 | 4MNDP2225C1001437 | 68499
59 | 2015 | Chevrolet | Silverado | 1GB4KYC88FF169639 | 1499 |  | 65268 |  | 1000 | 1000
60 | 2014 | Ford | Transit Conn | NMOLS7FX6E1164744 | 1499 |  | 24341 |  | 1000 | 1000 | Added 10/1/14 - Not on Quote
61 | 2015 | Cheverolet | 1500 Pickup | 1GCNCPEH2FZ211239 | 1499 |  | 20005 |  | 1000 | 1000 | Added 12-11-14
62 | 2014 | Ford | Transit Conn VAN | NM0LS7F79E1173325 | 1499 |  | 24951 |  | 1000 | 1000 | Added 12-11-14
63 | 2006 | Sterling | LT7500 Dump Truck | 2FZHATBS26AW81987 | 23479 |  | 57047 |  | 1000 | 1000 | Added 2-17-15
64 | 2015 | Ford | Transit Truck | [NAME] | 1499 |  | 23995 |  | 1000 | 1000 | Added 8-7-15
65 | 2015 | Freightliner | M2106 Truck | 3ALHCYCY1FDGS5462 | 21499 |  | 112097 |  | 1000 | 1000 | Added 8-7-15
66 | 2006 | Fontaine TB50GB | [NAME] | 4LFE4830363528309 | 68499 |  | 40950 |  | 1000 | 1000 | Added 10-8-15
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130