Looking for a way to match text within a cell to a lookup table

[lloyd1]

Hello, I'm searching for a way to match text that is embedded within a cell to a lookup table. For example, we receive product descriptions such as this: "HammerSilver2010v1.0" and I'd like to effectively run a query that if that product description has a certain word then it will give me a related ID. In this example, if the production description has "Silver" then give me the ID "400". I've been currently using a new column with the extract ("Silver") in Row 1 and the ID ("400") in Row 2 but the spreadsheet has become unstable because of the amount of data and columns. Is there a better way ~ perhaps with a separate lookup table? Thank you very much in advance for your help. Sheets below:

Column A: Production Descriptions
A3: HammerSilver2010v1.0
A4: NailGold2014v2.0

Column B - ZZ: Word Matches
B1: Silver
B2: 400
B3: =if(ISNUMBER(SEARCH(B$1,$A3),$B2,"")

 

[Aladin Akyurek]

Looks like...

=LOOKUP(9.99999999999999E+307,SEARCH(ProductDescList,$A3),ProductIdList)

 

[lloyd1]

Thank you very, very much!

 

[Aladin Akyurek]

Thank you very, very much!

You're very welcome.