Code to sort or match excel columns

Sarki Amada
Sarki Amada used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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?
Should you be charging more for 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 using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial