Using Excel VLOOKUP - Wildcard

Hello,

I am trying to use a vlookup wildcard using this formula - =VLOOKUP("*"& A1 &"*",Sheet1!$A:$A,1,FALSE), but it is not returning a value.

I was trying to get lookup value from a numerous number inside a table array. Hoping on your help on this.

Attached is the excel sample for my query.