VLOOK to exclude first character (apostrophe)

Hello

I have 2 files and I`m trying to write a vlookup in the file:

EH_master cra file to in column c, to say 'vlookup the barcode' in the file from EH_BC comma file but exclude 'the apostrophe' at the beginning. My actual files contain lots more barcodes, except one file has the barcodes with apostrophes at the begginning. I need to have the vlookup return to say whether the barcode exists in the EH_BC comma file (there's no match due to the barcodes having an apostrophe!)

Thank you so much

Please try at EH_BC comma.xlsx‎ F2

=VLOOKUP(--SUBSTITUTE(E2,"'",),'[EH_master cra file.xlsx]Sheet1'!$A$6:$B$999,2,)

hI Bo_Ry

Thank you for your reply. Sorry I may have not made myself clear. I need the data on the EH_master cra file (so the formula should be input on this file TO CHECK THE DATA FROM THE EH_BC comma file).

Thank you so much

You may use TEXT() function to convert EAN to string before vlookup.

ie.
original formula
=Vlookup( A1 , range , column_no , false )
to
=Vlookup( Text( A1, "0" ) , range , column_no , false )

Regards.