Check out some similar questions!

tonychoy · Nov 7, 2006, 06:03 AM

I have 2 excels.
Excel1: columns >> name; address
Excel2: columns >> name; phone; dob
Wish to join the two with matching "name".
I cannot find anything on Excel help.
I have downloaded some sharewares to handle this but either it failed to install or it does not function fully without payment.
Could anyone please help?
If you have some existing VBA or Macro codings and do not have time to explain. You can give the files to me.
Thanks

RickJ · Nov 7, 2006, 07:05 AM

If the names columns currently match, you could just copy and paste the Address Column into Excel2.

Stay tuned, though: we've got some Excel guru's here who might be able to offer a better answer.

ScottGem · Nov 7, 2006, 07:52 AM

That's because this is a DATABASE function, not really a spreadsheet function.

You could use Microsoft Query (under the Data menu) to join the 2 tables. You might also use a VLookup to add the address column to the phone table.

However, in either case, the names would have to match exactly. So John Smith would not match John J. Smith.

walt17 · Nov 20, 2006, 07:40 PM

Originally Posted by tonychoy

I have 2 excels.
Excel1: columns >> name; address
Excel2: columns >> name; phone; dob
Wish to join the two with matching "name".

Sort both excels by name.
Ensure that they both have the same number of rows. Insert blank rows if necessary. The names need to match, row for row.
Copy the address column from Excel 1 and paste it into Excel 2.

WvR · May 18, 2007, 02:09 AM

I agree with ScottGem Vlookup will work as long as the names are the same remember to add the "false" indicator at the end of your lookup, if you do not add it excel will return the nearest match and not the exact match and this can create chaos.

=vlookup(point to first name , select table you wish to join , column no e.g.2 or 3 , false)