MS Excel find a value using wildcards and Vlookup

Question

I'm trying to match these two serial numbers from two different sheets.

• 05/000/0423/114 <---- M1485
• 05/000/0423/0114

I have tried.

=VLOOKUP("*"&M1485&"*";Sheet2!$A$2:$H$411;1;FALSE)

but no use it return N/A

I can't do it manually because there is too many random serial numbers.