Try formatting the first column in your table as 'Text' and re-enter
your values.

Hope this helps!

In article ,
Budwho wrote:

Thanx for your responses, I made a table, altered the formula and I tried the
vlookup and it does not seem to return a result. All motor vehicle id
numbers have 17 digits regardless of make, model, etc...
every id number has a "Year digit" (10th from the left).

L = 1990
M = 1991
N = 1992
P = 1993
R = 1994

Letters that closely reseble numbers are omitted from the code.
after "Y" (2000), numbers identify the year.

1 = 2001
2 = 2002 etc...

the year number I need returned in cell B2 is not in "date" format it is
just a general number.
Just so you know where I am going with this.. Thanx again


"Budwho" wrote:

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