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
|
|||
|
|||
How to combine data from 2 separate workbooks onto 1 worksheet
I am planning a meeting for 100 attendees. Our database contains a unique ID
for each attendee as well as their name, mailing address, phone number, etc. I have another database that I received from our Travel Department containing the airline information (arrival date, arrival time, flight number, arrival airport, etc). How can I merge the 2 databases together into 1 database without having to copy/paste each attendee's information individually. Both databases have the unique ID for each attendee - is there a way to have Excel "find" the unique ID and then add columns with the additional information? |
#2
|
|||
|
|||
How to combine data from 2 separate workbooks onto 1 worksheet
Yes, you would normally use VLOOKUP for this, or an INDEX/MATCH
combination if the unique ID is not the first column of the file. As you did not give any indication of what columns you are using, I am unable to suggest a specific formula for you. Hope this helps. Pete On Mar 17, 6:35*pm, Kristen wrote: I am planning a meeting for 100 attendees. *Our database contains a unique ID for each attendee as well as their name, mailing address, phone number, etc. * I have another database that I received from our Travel Department containing the airline information (arrival date, arrival time, flight number, arrival airport, etc). How can I merge the 2 databases together into 1 database without having to copy/paste each attendee's information individually. *Both databases have the unique ID for each attendee - is there a way to have Excel "find" the unique ID and then add columns with the additional information? |
#3
|
|||
|
|||
How to combine data from 2 separate workbooks onto 1 worksheet
USe the VLOOKUP function to copy the data from one worksheet to another.
Irie! "Kristen" wrote: I am planning a meeting for 100 attendees. Our database contains a unique ID for each attendee as well as their name, mailing address, phone number, etc. I have another database that I received from our Travel Department containing the airline information (arrival date, arrival time, flight number, arrival airport, etc). How can I merge the 2 databases together into 1 database without having to copy/paste each attendee's information individually. Both databases have the unique ID for each attendee - is there a way to have Excel "find" the unique ID and then add columns with the additional information? |
Thread Tools | |
Display Modes | |
|
|