In sheet1 I have the following sample data (column B is what I am after):
clip.png

The code is what I want to find, and I have done it manually in this example. In sheet2 clip2.png I have a listing of strings and associated codes. The aim is to find the code automatically, for example in sheet1!B2 the formula should identify that the string "Abon" matches with code 87.

As there might be multiple occurrences it would be fine to stop at the first match.

Any ideas about how to achieve this?