From: Kristen on
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?
From: Pete_UK on
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 <Kris...(a)discussions.microsoft.com> 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?

From: Iriemon on
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?
 | 
Pages: 1
Prev: Print to file
Next: Moving cell formula