Set up a helper column in the sheet with wildcards to search the list of 10 digit numbers using the wildcards those numbers contain.

However, be aware that wildcard matching doesn't work on numeric values, so you will need to set up your list of 10 digit numbers as strings, eg: =1234567890&"" or have your numbers in a column (e.g. X) and then =$X1&"" in the search column.

Then, in the sheet with the list of 10 digit numbers, search for each number's own row number in the helper column of the wildcard sheet.

Thus:

Sheet1 . . . . . . . Sheet2
1234567890 . . . . . 31415*
9876543210 . . . . . 12345*
3141592653


In Sheet2, say Column B, set up "=MATCH($A1,Sheet1!$A:$A,0)" (where $A:$A is whatever column you have used to set up the text values of the numbers)

Then in Column B of Sheet1, set up "=MATCH(ROW(),Sheet2!$B:$B,0)"

This should yield:


Sheet1 . . . . . . . Sheet2
1234567890 . 2 . . . 31415* . 3
9876543210 . #N/A. . 12345* . 1
3141592653 . 1