Vba vlookup

[Cuscino]

Hi Everyone, VBA noob here (and new to this forum)

I m looking for a particular VBA vlookup that seeks multiple values in one cell separated by a comma (name of the product eg. FHGH, RDSD, etc), in another file

In this last one, we have: the values to find are in each single row, but they´re incorporated in a full sentence (eg. FHGH Product 12 6volt)

I would like the formula to return to me the sum of the values that are in the second column

I hope you could help me

Thanks