Merge 2 database
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)
"ch" wrote:
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.
|