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.
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.