How do I merge 2 excel spreadsheets containing some common info?

[Guest]

I have two spreadsheets containing different stats on people and I would like
to combine all of this information into one spreadsheet by "matching" the
people and pulling the data together. The people are all listed in one
column. the spreadsheets were created on different dates so there will not
always be a match of people from one spreadsheet to the other?

thanks for any help you can provide!

 

[Lotus123]

Two things I can think of:

1) Assuming the two spreadsheets have the same data...just differen
people (and same people; thus duplicates) - Copy all of the data int
one spreadsheet and then short by name. Then create an if() functio
in the last column to determine if the current record is identical t
the previous record...if it is, tag it as a "1"...if not..."0". Past
this new column as values when you are done and then sort by thi
column...all of the duplicates will get sorted to the bottom and ca
then be deleted. You could also do this with a pivot table; if yo
know how to use a pivot table.

2) Assuming the table has different info for the same people (one tabl
has address...other table has birtdays, etc). You a series of vlookup
to merge data between spreadsheets