Code to sort or match excel columns

I have an inventory list which has contains 1000 product with zero pictures, and a sheet which have 300 links of the product pictures in excel, I'm looking for a way to combine the two sheets, so that each product will match with its picture link.
NOTE:
Some of the links in the picture sheet contains partial, or full name of a product
The product sheet has a column with the names of the products
I'm using Excel 2016
I have Kutool Add-ins, Ablebit Tools Add-ins and Ablebit Data Add-ins installed.
How can I achieve this please help?
Thanks in advance.
Sarki AmadaIT Lab ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Can you upload sample and show expected result?
Sarki AmadaIT Lab ManagerAuthor Commented:
Hello @als315,

Thanks for youur response, attach is the file, The First sheet "Product list" is the sheet that contains the list of the productsProduct List The second sheet "Links of Product Images" contains the links of the imagesImage Links The last sheet is an example of how I want it to beFinal result each image link matches to the product.
Thank you.
Inventory.xlsx
als315Commented:
Do you have any criteria how to link positions? Only name of file?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Sarki AmadaIT Lab ManagerAuthor Commented:
Yes only file name, because only the file name exists in both the links and product list
als315Commented:
You will have problems with some images, where is added some text (with or without box, for example). I see only one line in main table. How do you like to resolve these duplicates?

Is it regular task or you need to do it only once?
als315Commented:
Look at sample. Some file names should be corrected to match source (Jack Daniel's etc.)
Inventory.xlsx
Sarki AmadaIT Lab ManagerAuthor Commented:
It's something I need to do once in a while, I was able to do it by using this formula.
Thank you for your time.
=IFERROR(VLOOKUP(C2,'Links of Product Images'!A:B,2,FALSE),"")

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sarki AmadaIT Lab ManagerAuthor Commented:
I solved it, and it works
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.