You might try a VLOOKUP.

=VLOOKUP(MID(F2,10,1),M1:N14,2,0)

Where F2 has the VIN # and M1 through M14 has a list of the letters and N1
through N14 has the years that correspond to each letter.

HTH
Regards,
Howard

"Budwho" wrote in message
...
I need to Identify the 10th character of F2 and return the correct year in
cell B2.
For example: F2 VIN# JM1HD4616N0112078 - THE "N" identifies the model
year
1992.
I need to recognize the10th digit and place "1992" in the "year" field.

I had trouble with wildcards in the "IF" function, any help would be
great!

A B C D E F
1 Stock # Year Description Color Miles VIN #
2 HT58904B MAZDA 929 BLK 36725 JM1HD4616N0112078