How to combine data from 2 separate workbooks onto 1 worksheet

K

Kristen

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?
 
P

Pete_UK

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
 

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

How do I combine information from two separate spreadsheets 2
Converting a list of fields to a single field 2
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
Match 2 set data and combine to 1set 2
How do I combine records from different sources 0
combining data from multiple workbooks 5
How do I automatically compile totals from 12 worksheets into 1? 2
How do I update worksheet 1 from data on worksheet 2 2

Top