+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Registered User
    Join Date
    11-23-2010
    Location
    Brighton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question 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
    Last edited by smwilson; 11-25-2010 at 08:47 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,726

    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.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-23-2010
    Location
    Brighton
    MS-Off Ver
    Excel 2010
    Posts
    4

    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
    Last edited by smwilson; 11-25-2010 at 08:49 AM.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,726

    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.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-23-2010
    Location
    Brighton
    MS-Off Ver
    Excel 2010
    Posts
    4

    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).
    Last edited by smwilson; 11-25-2010 at 08:51 AM.

  6. #6
    Registered User
    Join Date
    11-07-2012
    Location
    Newton Abbot
    MS-Off Ver
    Excel 2003
    Posts
    1

    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. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: Match email addresses on one sheet with email addresses on another sheet

    Magdalena,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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