I am trying to do a VLOOPUP using a barcode number which whilst it looks like a number is a actually a code.

Barcode displays as "9344213000091" but when I convert it to a general format it displays as "9.34421E+12"

In my second table the corresponding barcode number is actually a number not a code.

I am almost certain these two differing number formats are returning me my #N/A error.

How do I convert the coded barcode to a genuine number so the VLOOKUP will function. Or is there another way to get around this?

Screen Shot 2020-04-30 at 11.19.25 am.jpg