How do I merge 2 documents emails with names?

Question

How do I merge 2 documents emails with names?

Hi I wonder if anyone could help me.

I have a list of names in one csv and in another csv I have a much larger list of names with email addresses.

The names inside the bigger list contain all of the names from the smaller list plus loads more.

What I am trying to do is only transfer the email addresses from the bigger list that correspond with the names on the smaller list to the smaller list. So essentially I only end up with the smaller list's names and email addresses.

How is this done?

Any help would be greatly appreciated

Thanks

MacBook Pro (Retina, 15-inch, Mid 2015), iOS 10.3.3

Posted on Nov 11, 2017 2:00 AM

Reply

Answer 1

SGIII

Level 8

35,276 points

Nov 11, 2017 4:49 AM in response to Bigdougie2017

Here's a simple example of how you can do what you describe:

In B2 of 'Short', filled down the column:

=VLOOKUP(A2,Long::A:B,2,FALSE)

Open the two csv files in Numbers. Then copy one resulting table onto the same sheet as the other in the same document. Use a lookup formula (I used VLOOKUP but you could also use INDEX MATCH) in the shorter list to look up the email from the longer list. The "remove the formula by selecting the cells (here column B in 'Short'), typing commmand-c to copy, and (with the cells still selected) choosing Edit > Paste Formula Results from the menu.