Mixed text and number vlookup reference

Hi,

vlookup table reference are mixed text and numbers in excel. Am trying to vlookup value return N/A.

I would like the Vlookup amended so that If the numbers are stores as text on sheet.

The both of sheets as numbers/text on the sheet using the vlookup formula, it will return the correct information.

Your assistance in this regard is most appreciated.

file attached.