If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Quick way merge 2 databases using a unique field.
Hi Gurus,
I have 2 databases containin details of the same unique field eg serial number Is there a simple quick way to merge them by the unique serial number if the 2 databases are found on different sheets of the same work book ? Database 1 serial_number Field1 Field2 0001 xxx xxx 0002 xxx xxx .. . . .. . . 0xxx xxx xxx Database 2 serial_number Field3 Field4 0001 xxx xxx 0002 xxx xxx .. . . .. . . 0xxx xxx xxx |
#2
|
|||
|
|||
Quick way merge 2 databases using a unique field.
I believe VLOOKUP will be your new best friend.
Example: =VLOOKUP(A2,'Database 2'!A,3,FALSE) See XL help file for further detail. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ch" wrote: Hi Gurus, I have 2 databases containin details of the same unique field eg serial number Is there a simple quick way to merge them by the unique serial number if the 2 databases are found on different sheets of the same work book ? Database 1 serial_number Field1 Field2 0001 xxx xxx 0002 xxx xxx . . . . . . 0xxx xxx xxx Database 2 serial_number Field3 Field4 0001 xxx xxx 0002 xxx xxx . . . . . . 0xxx xxx xxx |
#3
|
|||
|
|||
Quick way merge 2 databases using a unique field.
Hi Luke,
Thanks for your reply. I am familiar with VLOOKUP and I was hoping for a more efficient way. Trouble with VLOOKUP is that I have to create the row and column reference for the VLOOKUP function, this can be quite tedious especially with larger records. Thanks anyway for your reply! |
Thread Tools | |
Display Modes | |
|
|