I'd review the notes for troubleshooting =vlookup() formulas from Debra
Dalgleish:

http://contextures.com/xlFunctions02.html#Trouble

Hamed parhizkar wrote:

I am copying and pasting into a spreadsheet vin #'s from a website. Then i am
copying and pasting my own vin#'s next to it. I have about 50 vin #'s that
are in the information that I copied from the website. I have done millions
of vlookup formula but its not recognizing the vins, I think it is not in a
number format. Sometimes a green error tab will pop up in the text and I can
then convert it to a number and it will work, but there is no error. I can
email the sheet to someone to see if you can help me. Thanks, I think its
something simple that I am missing.

Thanks

--

Dave Peterson