Extract Specific Numbers and Text from long string

Hi,

Can you please help me in extracting the code highlighted in red in column "C" to a seperate column "D" as shown in the below pic.
Column "C" contains list of codes and the codes I am looking for are both in TEXT & NUMBERS.
These codes in red will not be repeated in other products.


if possible, I prefer to use the "Model Version Code Table" as a ref. to provide more dynamic solution as I have a big list of codes and the below are just samples of data.
Attached is the sample excel sheet.

P.S. I'm using MS Excel 2016 and I am looking for a solution please only through "Formulas", not through "Text to Columns" option.

Product Codes Picture.png

Thanks in advance :)

Formula for D14 =INDEX(H:H,MAX(ISNUMBER(FIND(codes[Model Version Code],C3))*ROW(codes[Model Version Code])),1)

Formula for E14 =INDEX(I:I,MAX(ISNUMBER(FIND(codes[Model Version Code],C3))*ROW(codes[Model Version Code])),1)

Please try at
D14
=LOOKUP(0,-MATCH("*"&codes[Model Version Code]&"*",C14,),codes[Model Version Code])

E14
=VLOOKUP(D14,codes,2,0)