How to match exact value within a string of text (urls) and return said url as result?

Hi guys,

I'm trying to match the product code with the URL of the image it belongs to. The URL contains the product code as well but the product codes have a lot of similar values which gives me false positives in my main table. I want to do an exact match of the product code within the URLs and then return those URLs to the main table.

I've tried just about anything (xlookup, vlookup, find, if, countif) for my data sheet. It has 5000+ records so doing this manually is not an option.

Please help me out! Thanks in advance.

TechCom data products-images.xlsx