# Match email addresses on one sheet with email addresses on another sheet

1. ## Match email addresses on one sheet with email addresses on another sheet

Hi guys,

I currently have 2 spread sheets. Spreadsheet A has x amount of emails.

Spreadsheet B has x amount of emails including all of the emails in Spreadsheet A. It also includes information about all of the emails.

I need to find all emails in Spreadsheet A in Spreadsheet B including there relevant data. but i cant seem to do it.

Its a simple task but the only way I can get it working is by using the Find feature in spreadsheet B and typing in the email and copying and pasting the relevant cells. This would be fine but there are several thousand emails in Spreadsheet A and many more in Spreadsheet B

Kind Regards,
Sam

2. ## Re: Match email addresses on one sheet with email addresses on another sheet

Hi Sam, welcome again.

You almost certainly need to use the VLOOKUP function. I could explain it here but I would just be telling you the same thing you can learn by reading Excel HELP on the topic. See if that will solve your problem, return here for further guidance as needed.

We could provide the specific formulas needed if you attach your workbook, or even a version of it with a small sample of data so we can see how it's organized.

3. ## Re: Match email addresses on one sheet with email addresses on another sheet

Cheers, I have added a small example of a few of the names and addresses.

I had a look at the VLOOKUP but i couldn't quite get it. I haven't used excel for about 10 years so I'm a little rusty on how it works.

Many Thanks.
Sam

4. ## Re: Match email addresses on one sheet with email addresses on another sheet

I have attached a solution.

I noticed that you have real data in here; you probably don't want to leave people's emails and phone numbers hanging out here.

I modified my solution to use generic data but the format and formulas are exactly the same as for your workbook.

You will need to insert a new column all the way to the left in Sheet1, which just refers to the email addresses to the right. VLOOKUP looks in the first column of the range for the lookup value.

The formula I used in Sheet2 will work in all columns, all rows. You just need to copy it to where you need it.

5. ## Re: Match email addresses on one sheet with email addresses on another sheet

SOLVED

Thank you so much for your help. it saved me a lot of grief and I learnt allot. Sorry for the late response its been a hectic few days!!

many, many Thanks

Sam

PS I removed my attached link, it contained information which could have been abused.... 6StringJazzer solution works perfectly and is a direct replica of the file I uploaded (without the sensitive information).

6. ## Re: Match email addresses on one sheet with email addresses on another sheet

Hi there,

i seem to have the same issue; would anyone be able to assist me in matching random emails with a database containing some of the e mails?

I would be very greatful!!!

magdalena

7. ## Re: Match email addresses on one sheet with email addresses on another sheet

Magdalena,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1