asked on

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.

als315

Can you upload sample and show expected result?

Sarki Amada

ASKER

Hello @als315,

Thanks for youur response, attach is the file, The First sheet "Product list" is the sheet that contains the list of the products

The second sheet "Links of Product Images" contains the links of the images

The last sheet is an example of how I want it to be

each image link matches to the product.
Thank you.
Inventory.xlsx

als315

Do you have any criteria how to link positions? Only name of file?

Sarki Amada

ASKER

Yes only file name, because only the file name exists in both the links and product list

als315

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?

als315

Look at sample. Some file names should be corrected to match source (Jack Daniel's etc.)
Inventory.xlsx

ASKER CERTIFIED SOLUTION

Sarki Amada

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Sarki Amada

ASKER

I solved it, and it works