Spreadsheet: 813520d1673832924-help-with-looking-up-and-deciphering-vin-codes-using-lookups-worksheet-problem-001
Sheet: TEST DATABASE

BUILD YEAR |  |  | ASSEMBLY PLANT 1964.5 - 1973 |  |  | BODY STYLE - 1964.5, 1965, 1966 |  |  | ENGINE CODES - 1964.5
CODE | YEAR |  | CODE | PLANT |  | CODE | BODY STYLE |  | CODE | ENGINE
5 | 1965 |  | F | Dearborn, Michigan |  | 07 | Coupe |  | U | 170-1V  101 HP Inline 6 cyl
6 | 1966 |  | R | San Jose, California |  | 08 | Convertible |  | F | 260-2V  164 HP V8
7 | 1967 |  | T | Metuchen, New Jersey |  | 09 | Fastback |  | D | 289 -4V  210 HP V8
8 | 1968 |  |  |  |  |  |  |  | K | 289 -4V  271 HP V8 (Hi-Po)
9 | 1969 |  |  |  |  | BODY STYLE - 1967, 1968
0 | 1970 |  |  |  |  | CODE | BODY STYLE |  | ENGINE CODES - 1965, 1966
1 | 1971 |  |  |  |  | 01 | Coupe |  | CODE | ENGINE
2 | 1972 |  |  |  |  | 02 | Convertible |  | T | 200-1V  120 HP Inline 6 cyl
3 | 1973 |  |  |  |  | 03 | Fastback |  | C | 289-2V  200 HP V8
 |  |  |  |  |  |  |  |  | A | 289-4V  225 HP V8
 |  |  |  |  |  | BODY STYLE - 1969, 1970 |  |  | K | 289-4V  271 HP V8 (Hi-Po)
 |  |  |  |  |  | CODE | BODY STYLE
 |  |  |  |  |  | 01 | Hardtop |  | ENGINE CODES - 1967
 |  |  |  |  |  | 02 | Fastback |  | CODE | ENGINE
 |  |  |  |  |  | 03 | Convertible |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  | 04 | Hardtop Grande |  | C | 289 -2V  200 HP V8
 |  |  |  |  |  | 05 | Fastback Mach 1 |  | A | 289 -4V  225 HP V8
 |  |  |  |  |  |  |  |  | K | 289 -4V  271 HP V8 (Hi-Po)
 |  |  |  |  |  | BODY STYLE - 1971, 1972, 1973 |  |  | S | 390-4V 320 HP V8
 |  |  |  |  |  | CODE | BODY STYLE
 |  |  |  |  |  | 01 | Hardtop |  | ENGINE CODES - 1968
 |  |  |  |  |  | 02 | Sports Roof |  | CODE | ENGINE
 |  |  |  |  |  | 03 | Convertible |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  | 04 | Hardtop Grande |  | C | 289 -2V  200 HP V8
 |  |  |  |  |  | 05 | Sports Roof Mach 1 |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  |  |  | J | 302 -4V  230 HP V8
 |  |  |  |  |  |  |  |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  |  |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  |  |  | W | 427 -4V  390 HP V8
 |  |  |  |  |  |  |  |  | ENGINE CODES - 1969
 |  |  |  |  |  |  |  |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  | L | 250 -1V  155 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  |  |  | H | 351W -2V  250 HP  V8
 |  |  |  |  |  |  |  |  | M | 351W-4V  290 HP  V8
 |  |  |  |  |  |  |  |  | G | 302 -4V  290 HP (Boss) V8
 |  |  |  |  |  |  |  |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  |  |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  |  |  | Q | 428 -4V  335 HP V8(Cobra Jet)
 |  |  |  |  |  |  |  |  | Z | 429 -4V  375 HP V8 (Boss)
 |  |  |  |  |  |  |  |  | ENGINE CODES - 1970
 |  |  |  |  |  |  |  |  | CODE | ENGINE
 |  |  |  |  |  |  |  |  | T | 200 -1V  120 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  | L | 250 -1V  155 HP Inline 6 cyl
 |  |  |  |  |  |  |  |  | F | 302 -2V  210 HP V8
 |  |  |  |  |  |  |  |  | G | 302 -4V  290 HP V8 (Boss)
 |  |  |  |  |  |  |  |  | H | 351 -2V  250 HP V8 (Windsor or Cleveland)
 |  |  |  |  |  |  |  |  | M | 351C -4V  290 HP V8
 |  |  |  |  |  |  |  |  | S | 390 -4V  320 HP V8
 |  |  |  |  |  |  |  |  | R | 428 -4V  335 HP V8
 |  |  |  |  |  |  |  |  | Q | 428 -4V  335 HP V8 (Cobra Jet)
 |  |  |  |  |  |  |  |  | Z | 429 -4V  375 HP V8 (Boss)
 |  |  |  |  |  |  |  |  | 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