Here is a function that may help. It is similar to Match(), but uses
InStr() to return the position of lookup_value in lookup_array if
lookup_value is contained  anywhere in the cells  of lookup_array.

Then, you can use INDEX() to get the identification number.


Function Match2(lookup_value, lookup_array)
n = 1
For Each c In lookup_array
If InStr(c, lookup_value) > 0 Then
Match2 = n
Exit Function
End If
n = n + 1
Next
Match2 = False
End Function