Need to map bulk list of urls from another list in excel using vlookup or similar

Hi everyone,
I am facing an issue to map the urls from one list to another. One list has around 1000 urls in different format (magento based) and the other list contains urls (1000) in shopify format. I couldn't find any primary key to map all these urls accordingly.
So, what I am trying to figure out is -
A formula/string/script that can map and vlookup the urls from one sheet to another if I add multiple text (as in "gucci", "versace" etc.) and if anyone of them or all of them exists in any url in the previous list they all comeup into the other against the corresponding url as the vlookup works.
Let me share an example here for better understanding -

Magento based format -
Commercial links deleted by moderation

Shopify based urls -
Commercial links deleted by moderation

So I need to create a formula using vlookup (or any other which can work) to match multiple text ("paco-rabanne", "million", "men") in the list of shopify based urls and run that against Magento based urls and then import the best matched urls in front of the shopify based url respectively.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are a new member I will add it for you this time. Please read forum rules...

https://chandoo.org/forum/threads/ne...similar.43567/

Administrative Note:

Welcome to the forum.

Unfortunately your post does not comply with Rule #10 of our Forum RULES:

Do not put links to commercial sites or services or to competing forums in signatures and posts.

We do not allow advertising, the promotion of your own commercial ventures or the deliberate promotion of other competing fora here.



I have removed all commercial links from your original posts. please mock-up examples that do not contain commercial links so that assistance can be offered. Thanks