Merge 2 database

C

ch

Hi Everybody,

I'm trying to merge 2 databases (both in .csv files) using Excel, each
having about 8 fields. I need to merge them by 2 Fields "SerialNumber" and
"MachineNumber".

Can anybody help? Thanks in advance.
 
J

joel

Usually macros are the best method. Another alternative is to use SumProduct
which is need if you are doing a table lookup using two columns.

Put each CSV file on a seperate worksheet

Then add the mising columns from sheet two into sheet 1.

So if you are looking up columns A and column b and getting data in column C
use this

=SumProduct(--(A1=Sheet2!A1:A100),--(B1=Sheet2!B1:B100),Sheet2!C1:C100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging data from 2 data excel sheets 2
Quick way merge 2 databases using a unique field. 2
Using Excel values in Word Mail Merge 3
Mail Merge Functionality 1
Line Up Two Columns In Excel 2
merging 2 excel databases using unique identifiers 1
Merge 2 Excel Worksheets 4
Merge two files based on one column 1

Top