I need advise on how to combine 3 Excel Spreadsheets using a unique id!!

**Mayanja** · 05-14-2013, 08:49 AM

Hey guys excel experts. I have I small problem that I hope you guys can help me with.

I have tried reading in the forum and google but I have not yet found the answer am looking for.

So I have three files that I need to combine using a unique Id:

File A: This File include the following colums. Stock_Code, Vendor, Price... etc

File B: This File includes: StockCode: ManufacturerID, ProductDetails, Image;...... etc

File C: This file includes: StockCode, ServingSizeText,... etc

I want to combine all 3 files in a database utilizing stock_code as the unique identifier .. how do I do that?

I have tried coping them and put them in one file but then I am not utilizing stock_code.

any help on how I can do this I have looked at a forum by

http://www.excelforum.com/excel-form...dentifier.html

but there is some thing missing and i can't use

thanks for reading his

**bstoyano** · 05-14-2013, 10:20 AM

Hi,
A possible solution to your problem is to copy-paste in a new sheet the stock_code and then using vlookup to add the values of the columns (e.g. database fields) you need.

**Mazzaropi** · 05-14-2013, 11:59 AM

Mayanja, Good Afternoon.

Have some of your files an official list of StockCode or you must search all the three files to compound a complete list of StockCode?

After creating this DATABASE all updates will occur on this file OR the others threes files will continue to receiving updates?

I believe that your necessity is not complex to implement, BUT we need to know more about your data and your operational process.

Have a nice day.

Best wishes from Brazil.

**Mayanja** · 05-15-2013, 07:45 AM

Hey Sofia and Marcílio

Thanks for your Help I used vlookup, and It solved the problem and also when I change something in the other files .. the vlookup updates the master files. Thanks alot for your advise

Now i have another question. Do you guys know how too insert a photo into an excel cell? I donot mean the all photo but a reference to the photo?

Thanks alot

**Mazzaropi** · 05-15-2013, 08:52 AM

Mayanja, Good morning.

As you didn´t mentioned the goal to insert a "reference" at a Excel, our help may not be so conclusive as I desire.

You can use the function HYPERLINK to do this.
With this function the photo can be inside another tab of your excel file or at your harddrive or at some URL (web).

You can do this interactively too.
Click right button on any cell of your tab.

At the bottom of dialog windows will appears an option to insert a link that can be used to link, photo, docs, pdf or what you want to maintain a link to.

Is it what you desire?

I hope it helps.

Best wishes from Brazil!

**Mayanja** · 05-15-2013, 10:41 AM

Good Afternoon to you to Marcílio and thanks for anwering

I am not 100 percent sure if that option will work but I am going to try it!

But to try to explain what I want in simple terms:

After I have combined the three Excel Spreadsheets now I have

Stock_Code, Vendor, Price, product details.... etc.. alle are in different columns, (which is what I wanted:-) one of the columns is Image!! I want to reference the images in my database. How do I do that??
The goal is to upload this database on my website. Do you think it will work if I use the function HYPERLINK??

Thanks again for replying

**Mazzaropi** · 05-15-2013, 10:32 PM

Mayanja, Good evening.

"...alle are in different columns, (which is what I wanted:-) one of the columns is Image!! I want to reference the images in my database. How do I do that??
The goal is to upload this database on my website..."

I believe that HYPERLINK function won´t work to this specific case.

Take a look at these places.
All of them were mentioned here at ExcelForum as reference for this kind of necessity like yours.

A) http://www.contextures.com/excelfilesRon.html#RCH0002

b) http://www.mcgimpsey.com/excel/lookuppics.html
c) http://www.jkp-ads.com/articles/ShowPicture00.asp
d) http://www.andypope.info/fun/picviewer.htm

I hope this helps.

Tell us if it worked for you.

Best wishes from Brazil!