Spreadsheet: 813623d1673885663-help-with-looking-up-and-deciphering-vin-codes-using-lookups-worksheet-problem-001-response
Sheet: Data Layout

 | There is no difference in the data, I have just converted it to a table for ease of maintenance. |  |  | There is no difference in the data, I have just converted it to a table for ease of maintenance. |  |  | Have converted all the individual year codes into one look up table.  I have also included Model Year as [NAME]  to make it easier to maintain. |  |  |  |  |  | I have converted all the engine codes for each year into a single table. I have included a Model Year Lookup to allow for checking that correct engine code and year are aligned.  There is no entries for the 1964.5 Engines.  If you want to add them I would suggest adding them possibly under code for year 1965.
 | BUILD YEAR |  |  | ASSEMBLY PLANT 1964.5 - 1973
 | CODE | YEAR |  | CODE | PLANT |  | Year Code | Model Year | Code | Lookup | Body Style |  | Year Code | Model Year | Engine Code | Lookup | Engine |  | ENGINE CODES - 1964.5
 | 5 | 1965 |  | F | Dearborn, Michigan |  | 5 |  | 07 |  | Coupe |  | 5 |  | T |  | 200-1V  120 HP Inline 6 cyl |  | CODE | ENGINE
 | 6 | 1966 |  | R | San Jose, California |  | 5 |  | 08 |  | Convertible |  | 5 |  | C |  | 289-2V  200 HP V8 |  | U | 170-1V  101 HP Inline 6 cyl
 | 7 | 1967 |  | T | Metuchen, New Jersey |  | 5 |  | 09 |  | Fastback |  | 5 |  | A |  | 289-4V  225 HP V8 |  | F | 260-2V  164 HP V8
 | 8 | 1968 |  |  |  |  | 6 |  | 07 |  | Coupe |  | 5 |  | K |  | 289-4V  271 HP V8 (Hi-Po) |  | D | 289 -4V  210 HP V8
 | 9 | 1969 |  |  |  |  | 6 |  | 08 |  | Convertible |  | 7 |  | T |  | 200 -1V  120 HP Inline 6 cyl |  | K | 289 -4V  271 HP V8 (Hi-Po)
 | 0 | 1970 |  |  |  |  | 6 |  | 09 |  | Fastback |  | 7 |  | C |  | 289 -2V  200 HP V8
 | 1 | 1971 |  |  |  |  | 7 |  | 01 |  | Coupe |  | 7 |  | A |  | 289 -4V  225 HP V8 |  | ENGINE CODES - 1965, 1966
 | 2 | 1972 |  |  |  |  | 7 |  | 02 |  | Convertible |  | 7 |  | K |  | 289 -4V  271 HP V8 (Hi-Po) |  | CODE | ENGINE
 | 3 | 1973 |  |  |  |  | 7 |  | 03 |  | Fastback |  | 7 |  | S |  | 390-4V 320 HP V8 |  | T | 200-1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 8 |  | 01 |  | Coupe |  | 6 |  | T |  | 200-1V  120 HP Inline 6 cyl |  | C | 289-2V  200 HP V8
 |  |  |  |  |  |  | 8 |  | 02 |  | Convertible |  | 6 |  | C |  | 289-2V  200 HP V8 |  | A | 289-4V  225 HP V8
 |  |  |  |  |  |  | 8 |  | 03 |  | Fastback |  | 6 |  | A |  | 289-4V  225 HP V8 |  | K | 289-4V  271 HP V8 (Hi-Po)
 |  |  |  |  |  |  | 9 |  | 01 |  | Hardtop |  | 6 |  | K |  | 289-4V  271 HP V8 (Hi-Po)
 |  |  |  |  |  |  | 9 |  | 02 |  | Fastback |  | 8 |  | T |  | 200 -1V  120 HP Inline 6 cyl |  | ENGINE CODES - 1967
 |  |  |  |  |  |  | 9 |  | 03 |  | Convertible |  | 8 |  | C |  | 289 -2V  200 HP V8 |  | CODE | ENGINE
 |  |  |  |  |  |  | 9 |  | 04 |  | Hardtop Grande |  | 8 |  | F |  | 302 -2V  210 HP V8 |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 9 |  | 05 |  | Fastback Mach 1 |  | 8 |  | J |  | 302 -4V  230 HP V8 |  | C | 289 -2V  200 HP V8
 |  |  |  |  |  |  | 0 |  | 01 |  | Hardtop |  | 8 |  | S |  | 390 -4V  320 HP V8 |  | A | 289 -4V  225 HP V8
 |  |  |  |  |  |  | 0 |  | 02 |  | Fastback |  | 8 |  | R |  | 428 -4V  335 HP V8 |  | K | 289 -4V  271 HP V8 (Hi-Po)
 |  |  |  |  |  |  | 0 |  | 03 |  | Convertible |  | 8 |  | W |  | 427 -4V  390 HP V8 |  | S | 390-4V 320 HP V8
 |  |  |  |  |  |  | 0 |  | 04 |  | Hardtop Grande |  | 9 |  | T |  | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 0 |  | 05 |  | Fastback Mach 1 |  | 9 |  | L |  | 250 -1V  155 HP Inline 6 cyl |  | ENGINE CODES - 1968
 |  |  |  |  |  |  | 1 |  | 01 |  | Hardtop |  | 9 |  | F |  | 302 -2V  210 HP V8 |  | CODE | ENGINE
 |  |  |  |  |  |  | 1 |  | 02 |  | Sports Roof |  | 9 |  | H |  | 351W -2V  250 HP  V8 |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 1 |  | 03 |  | Convertible |  | 9 |  | M |  | 351W-4V  290 HP  V8 |  | C | 289 -2V  200 HP V8
 |  |  |  |  |  |  | 1 |  | 04 |  | Hardtop Grande |  | 9 |  | G |  | 302 -4V  290 HP (Boss) V8 |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  | 1 |  | 05 |  | Sports Roof Mach 1 |  | 9 |  | S |  | 390 -4V  320 HP V8 |  | J | 302 -4V  230 HP V8
 |  |  |  |  |  |  | 2 |  | 01 |  | Hardtop |  | 9 |  | R |  | 428 -4V  335 HP V8 |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  | 2 |  | 02 |  | Sports Roof |  | 9 |  | Q |  | 428 -4V  335 HP V8(Cobra Jet) |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  | 2 |  | 03 |  | Convertible |  | 9 |  | Z |  | 429 -4V  375 HP V8 (Boss) |  | W | 427 -4V  390 HP V8
 |  |  |  |  |  |  | 2 |  | 04 |  | Hardtop Grande |  | 0 |  | T |  | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 2 |  | 05 |  | Sports Roof Mach 1 |  | 0 |  | L |  | 250 -1V  155 HP Inline 6 cyl |  | ENGINE CODES - 1969
 |  |  |  |  |  |  | 3 |  | 01 |  | Hardtop |  | 0 |  | F |  | 302 -2V  210 HP V8 |  | CODE | ENGINE
 |  |  |  |  |  |  | 3 |  | 02 |  | Sports Roof |  | 0 |  | G |  | 302 -4V  290 HP V8 (Boss) |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  | 3 |  | 03 |  | Convertible |  | 0 |  | H |  | 351 -2V  250 HP V8 (Windsor or Cleveland) |  | L | 250 -1V  155 HP Inline 6 cyl
 |  |  |  |  |  |  | 3 |  | 04 |  | Hardtop Grande |  | 0 |  | M |  | 351C -4V  290 HP V8 |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  | 3 |  | 05 |  | Sports Roof Mach 1 |  | 0 |  | S |  | 390 -4V  320 HP V8 |  | H | 351W -2V  250 HP  V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | R |  | 428 -4V  335 HP V8 |  | M | 351W-4V  290 HP  V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Q |  | 428 -4V  335 HP V8 (Cobra Jet) |  | G | 302 -4V  290 HP (Boss) V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | Z |  | 429 -4V  375 HP V8 (Boss) |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | L |  | 250 -1V  155 HP Inline 6 cyl |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | F |  | 302 -2V  210 HP V8 |  | Q | 428 -4V  335 HP V8(Cobra Jet)
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | H |  | 351 -2V  250 HP V8 |  | Z | 429 -4V  375 HP V8 (Boss)
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | M |  | 351C-4V  290 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | Q |  | 351C-4V  280 HP V8 (Cobra Jet) |  | ENGINE CODES - 1970
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | R |  | 351C-4V  330 HP V8 (Boss) |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | C |  | 429-4V  370 HP V8 (Cobra Jet) |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | J |  | 429 -4V  370 HP V8 (Cobra Jet Ram Air) |  | L | 250 -1V  155 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | L |  | 250 -1V    95 HP Inline 6 cyl |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | F |  | 302 -2V  136 HP V8 |  | G | 302 -4V  290 HP V8 (Boss)
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | H |  | 351 -2V  168 HP V8 |  | H | 351 -2V  250 HP V8 (Windsor or Cleveland)
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Q |  | 351 -4V  248 HP V8 |  | M | 351C -4V  290 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | R |  | 351C-4V  275 HP V8 351HO |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | L |  | 250 -1V    95 HP Inline 6 cyl |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | F |  | 302 -2V  136 HP V8 |  | Q | 428 -4V  335 HP V8 (Cobra Jet)
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | H |  | 351 -2V  168 HP V8 |  | Z | 429 -4V  375 HP V8 (Boss)
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | Q |  | 351 -4V  248 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENGINE CODES - 1971
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 250 -1V  155 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 351 -2V  250 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 351C-4V  290 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 351C-4V  280 HP V8 (Cobra Jet)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | 351C-4V  330 HP V8 (Boss)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 429-4V  370 HP V8 (Cobra Jet)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 429 -4V  370 HP V8 (Cobra Jet Ram Air)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENGINE CODES - 1972
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 250 -1V    95 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 302 -2V  136 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 351 -2V  168 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 351 -4V  248 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | 351C-4V  275 HP V8 351HO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENGINE CODES - 1973
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 250 -1V    95 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 302 -2V  136 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 351 -2V  168 HP V8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 351 -4V  248 HP V8