+ Reply to Thread
Results 1 to 2 of 2

Compare two email for a match and then paste data from a corrisponding cell

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    1

    Compare two email for a match and then paste data from a corrisponding cell

    I needed to compare email addresses from two different worksheets. If there is a match, then I need the data in corresponding cell, but different column, to paste into worksheet one.

    Worksheet 1: Has an incomplete list of last names, but has the emails.
    A: First Name, B: Last Name, C: Emails

    Worksheet 2: Has all of the complete information. However, it's a large database that has contacts I do not need.
    A: First Name, B: Last Name, C: Emails.

    If emails are the same on both worksheets, I want to insert the last name matching that email from worksheet 2 into the Last Name cell that corresponds with the matching email on worksheet 1.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Compare two email for a match and then paste data from a corrisponding cell

    Maybe something like this in Sheet1!B2:
    =INDEX(SHEET2!B:B,MATCH(SHEET1!C2,SHEET2!C:C,0))
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare two columns and copy and paste data from a third column when a match is found
    By GatorsBucs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2013, 06:54 PM
  2. Compare 2 columns then copy and paste the adjucent cell value if match is found
    By smartisenthil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2012, 12:11 PM
  3. Replies: 6
    Last Post: 05-30-2012, 03:09 PM
  4. Compare, copy an paste if values match each other!
    By littledic in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-31-2011, 04:14 AM
  5. Replies: 20
    Last Post: 01-02-2011, 10:00 PM

Tags for this Thread

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