Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 database
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Mail merge invoice from excel database | Excel Discussion (Misc queries) | |||
merge database or sort? | Excel Worksheet Functions | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
Can I create a database to merge an organizational chart | Excel Discussion (Misc queries) | |||
Excel database - merge to Word | Excel Worksheet Functions |