Matching information from a product feed and importing it into another excel sheet

If you need to do this once thenit can be done with this formula that you would put in the UPC column of your products file.

Please Login or Register  to view this content.

WHERE:
[Book2]Sheet1| is the workbook and sheet of your other products file based on company.

$A$2:$B$10 is the range of cells in Book2 file where the formula will find the ID and the UPC. The ID column should be the first one. The UPC column can be any one column. You'll just have to change the 2 in the formula to the number of columns between the ID one and the UPC one (counting the ID column)

A2 at the beginning of the formula points to the ID in your products file. Usually it is in the same row where you want the UPC to appear.

Then you copy this formula down your table. It should gives you all of your UPC.
IN fact, you created a link between your 2 workbooks. You can leave it this way and if you happen to change a upc in the original file it will be updated in the products file. Or you can copy that UPC column and paste only the value at the same place. You no longer have a link with the other file.

It can also be done with a macro if you have to do it regularly.
Let me know if it is needed.

Sure, in the formula, you change Book2 (which is the file name) with your other files name. When you do this the first time, it is easier to do it with all files opened.
When it is done, you can close those files and the links remain active. Excel will ask you to update them when you open the product file with all the formulas. You have the choice to update data if you know there are new products or do not update if it is not necessary.

See attached files for a working example.
Save all 3 files in the same folder.
Open only Product-file.xlsx workbook to see what Excel will ask you. It will ask you:
This workbook contains links to other data sources.
You can click on Update or Don't update.
Now, look at formulas in UPC columns. See how they refer to the others workbooks.
To create such formulas, it is easier to do it with all of your linked files open.
Files do not need to be in the same folder. If you save one of the linked file to another location, the link should follow the new location.
Hope this helps you.