Vlookup Error

[JTJK19]

I have a spreadsheet with two tabs, tab one is consumer and 2nd is my inventory. Consumer billing document contains 9-10 digits vs my inventory which is 8 digits. so naturally i did =right(b2,len(b2)-1) this works perfectly.
Now when i try to do a vlookup i get an error. I have checked to ensure that both are free of any hidden characters or spaces. Both are set to same parameter general (i have tried txt, number) but if I just type out the number works like a charm. Any suggestions what the issue could
Many thank in advance

 

[Joe4]

With VLOOKUP, the values you are looking up MUST be the same data type as the list you are matching against.
One of the most common problems is when people try to compare numbers to text (they look numbers, but are really entered as text).

You can easily confirm this with the ISNUMBER function.
First apply it to the value you are looking up (i.e. =ISNUMBER(C2) ), then apply it to one of the entries in your list.
They should either both return TRUE or both return FALSE. If one returns TRUE and one returns FALSE, then they are not the same data type.

To check for any extra characters, the LEN function will do.
I have some data that comes from the web or other programs sometimes have blank special spaces that mess up the match.
So use the LEN function to confirm both are the same length.