We help IT Professionals succeed at work.

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.
Comment
Watch Question

Can you upload sample and show expected result?
Sarki AmadaIT Lab Manager

Author

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
Do you have any criteria how to link positions? Only name of file?
Sarki AmadaIT Lab Manager

Author

Commented:
Yes only file name, because only the file name exists in both the links and product list
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?
Look at sample. Some file names should be corrected to match source (Jack Daniel's etc.)
Inventory.xlsx
IT Lab Manager
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),"")
Sarki AmadaIT Lab Manager

Author

Commented:
I solved it, and it works