Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

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

Reply

Page content loaded

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

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


User uploaded file


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.


More on VLOOKUP here.


SG

Nov 11, 2017 4:49 AM

Reply Helpful
User profile for user: Bigdougie2017

Question: How do I merge 2 documents emails with names?