Spreadsheet: 473656d1470320820-matching-up-vin-numbers-from-two-different-worksheets-vlookup-xlf-vin-lookup
Sheet: Sheet1

AUTOMOBILE SCHEDULE
 |  |  |  |  |  | TOTAL OCN | 4300
No. | Year | Make | Model | Vin No. | Class Codes | Valuation | Cost New | Comprehensive Deductible | Collision Deductible
1 | 2012 | Chevrolet | 1500RE | 1GCNCPEX1CZ3 21685 |  |  |  | 1000 | 1000
2 | 2015 | Dodge | Ram 3500 | 3C7WRTCL3FG599829 |  |  |  | 1000 | 1000
3 | 1996 | Ford | F-800 | 1FDXF80E1TVA27542 |  |  |  | 1000
4 | 2016 | GMC | Canyon | 1GTH5BE37G1106890 |  |  |  | 1000 | 1000
5 | 1999 | Ford | F-250 | 1FTNF20F2XEB82995 |  |  |  | 1000
6 | 1999 | [NAME] | Dump | 4TOFB2523X1005725
7 | 2001 | Ford | F-250 | 1FTNF20F91EC19273 |  |  |  | 1000
8 | 2012 | Chevrolet | 1500RE | 1GCNCPEX9 CZ141225 |  |  |  | 1000 | 1000
9 | 2001 | Ford | F-450 | 1FDXW46F71EC83190 |  |  |  | 1000
10 | 2002 | Ford | [NAME] | 1FTRF17W02NB39248 |  |  |  | 1000
11 | 2002 | Ford | [NAME] | 1FTRF17W22NB39249 |  |  |  | 1000
12 | 2003 | Ford | [NAME] | 2FTRX18W63CB12896 |  |  |  | 1000
13 | 2002 | Ford | [NAME] | 1FTRX1 8L92NB39251 |  |  |  | 1000
14 | 2006 | Utility | Trailer | 1RCFFCJ1161000471 |  |  |  | 1000 | 1000
15 | 2006 | Fontaine TB50GB | 50 [NAME] | 4LFE4830363528309 |  |  |  | 1000 | 1000
16 | 2006 | Ford | [NAME] | 1FTRX12W46FB09187 |  |  |  | 1000 | 1000
17 | 2006 | Ford | F-250 | 1FTSW21P06ED42588 |  |  |  | 1000 | 1000
18 | 2015 | Chev | Silverado | 1GCNCPEH6FZ431791 |  |  |  | 1000 | 1000
19 | 2016 | PJ | Trailer | 4P5CC2027G1242957 |  |  |  | 1000 | 1000
20 | 2006 | Ford | [NAME] | 1FTSF20P06ED35111 |  |  |  | 1000 | 1000
21 | 2007 | Ford | F-350 | 1FDWW37Y18EA14943 |  |  |  | 1000 | 1000
22 | 2008 | Inter- national | 4400 | 1HTMKAAN88H649282 |  |  |  | 1000 | 1000
23 | 2007 | Haulass | Trailer | 5JYLB35237P071392
24 | 2006 | Goose- neck | Trailer | 1T9GF28286L847042
25 | 2007 | Chevy Van Express | [NAME] | 1GCGG25V171145501 |  |  |  | 1000 | 1000
26 | 2009 | Chevy | Colorado | 1GCCS19E098104269 |  |  |  | 1000 | 1000
27 | 2013 | Chevy | 1500 | 1GCNCPEXXDZ235521 |  |  |  | 1000 | 1000
28 | 2009 | Ford | Ranger | 1FTYR14E39PA23 815 |  |  |  | 1000 | 1000
29 | 2006 | Reinco | Trailer | 1R97312176P195012
30 | 2009 | Hooper | Flatbed | 4T0FBO61991000834
31 | 2013 | Chevy | 1500 | 1GCNCPEX5DZ2 64778 |  |  |  | 1000 | 1000
32 | 2004 | Hooper | Trailer | 4TOFB162741004937
33 | 2003 | [NAME] | GV54464 | 4TOFB081531004674
34 | 2005 | [NAME] | GV54586 | 4TOFB252551002998
35 | 2009 | Ranger | [NAME] | 1FTYR14E69PA51477 |  |  |  | 1000 | 1000
36 | 2005 | [NAME] | GV54590 | 4TOFB252951003734
37 | 2007 | Carry On 16x12 | Enclosed Trailer | 4YMCL12147G084287
38 | 20 IT | Ford | Ranger | 1FTKRIED9 BP A4 8462 |  |  |  | 1000 | 1000
39 | 2011 | GMC | Sierra | 3GTP2WE37BG254821 |  |  |  | 1000 | 1000
40 | 2012 | Chevy | 1500 | 1GCRCPEX9CZ109523 |  |  |  | 1000 | 1000
41 | 2012 | Chevy | 2500 | 1GB0CVCG7CF115701 |  |  |  | 1000 | 1000
42 | 2012 | Chevy | 2500 | 1GB0CVCG1CF115354 |  |  |  | 1000 | 1000
43 | 2012 | GMC | 3500Crew | 1GT422C80CF167761 |  |  |  | 1000 | 1000
44 | 2008 | [NAME] | liner | 1FVXAU00X8PZ73624 |  |  |  | 1000 | 1000
45 | 2003 | Ford | F350 | 1FDSW30L43EC95979 |  |  |  | 1000 | 1000
46 | 2012 | Chevy | 1500ex | 1GCRKPRA3CZ351786 |  |  |  | 1000 | 1000
47 | 2003 | Ford | F450(WS1208) | 1FDXX47P43EC95742 |  |  |  | 1000
48 | 2003 | Ford | F450 | 1FDXX47P43EC95739 |  |  |  | 1000
49 | 2013 | Chevy | 1500 | 1GCNCPEX9DZ384387 |  |  |  | 1000 | 1000
50 | 2013 | Chevy | 3500 | LGD422C88DF208392 |  |  |  | 1000 | 1000
51 | 2013 | Chevy | 1500 | 1GTN1THX5DZ170088 |  |  |  | 1000 | 1000
52 | 2013 | Ford | F150 | 1FTFW1EF2DFD7018 5 |  |  |  | .
53 | 2014 | Chevy | Silverado | 1GB4KZC8 5EF139244 |  |  |  | 1000 | 1000
54 | 2014 | Ford F450 | Sewer | 1FDUF5HT3EEB53229 |  |  |  | 1000 | 1000
55 | 2015 | Chevrolet | Silverado | 1GB4KYC88FF169639 |  |  |  | 1000 | 1000
56 | 2013 | Hooper | 7x20 | 4TOFB2024D1001167 |  |  |  | 1000 | 1000
57 | 2012 | Better | Built | 4MNDP2225C1001437
58 | 2014 | Ford | Transit | KMOLS7FX6E1164744
59 | 2015 | Chevy | 1500re | 1GCNCPEH2FZ211239 |  |  |  | 1000 | 1000
60 | 2014 | Ford | Transit | NM0LS7F79E1173325 |  |  |  | 1000 | 1000
61 | 2015 | Dodge | Ram 3500 | 3C7WRTCL5FG599878 |  |  |  | 1000 | 1000
62 | 2015 | Ford | Transit | NMOLS7E72F1208015 |  |  |  | 1000 | 1000
63 | 2015 | Freight- liner | M2106 | 3ALHCYCY1FDGS5462 |  |  |  | 1000 | 1000
64 | 1994 | Ford L9000 | Big | 1FDYU90U4SVA7642Q |  |  |  | 1000 | 1000
65 | 2007 | SMP | Reel | 1RCFFCJ1161000471 |  |  |  | 1000 | 1000
66 | 2016 | PJ | Trailer | 4P5CC2027G1242957 |  |  |  | 1000 | 1000
67 |  | Look | Trailer | 53BLTEA23HU023246 |  |  |  |  |  | Liability Only