+ Reply to Thread
Results 1 to 3 of 3

Matching Data in Two Columns and then Pasting Data from Third Column to Fourth Column

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    32

    Matching Data in Two Columns and then Pasting Data from Third Column to Fourth Column

    Hello- I'm not sure if what I'm trying to do is technically possible, but maybe someone can help.

    Let's say I have 100 unique email addresses in Column A. Column B has some data associated with each e-mail address (so A and B have the same number of rows). Column C has 50 unique e-mail addresses, some of which are in Column A. Is it possible to find matches between columns A and C, and then put the data from Column B into the correct cell in Column D so that it's next to the correct e-mail address in Column C?

    Thank you for any help!

  2. #2
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Re: Matching Data in Two Columns and then Pasting Data from Third Column to Fourth Column

    I think you're looking for a VLOOKUP, attached.
    Attached Files Attached Files
    Last edited by Mvaldesi; 09-20-2017 at 12:21 PM.

  3. #3
    Registered User
    Join Date
    04-04-2013
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: Matching Data in Two Columns and then Pasting Data from Third Column to Fourth Column

    This works perfectly. Thank you so much!!

+ 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. Pasting a new unique column from six columns of data
    By ctownballer03 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-27-2016, 09:29 PM
  2. Copying data from a row with many columns and pasting with column rearranged
    By ivector in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2014, 07:20 AM
  3. Selecting data from every fourth column
    By Lassebn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2013, 04:27 AM
  4. Comparing two columns of data and pasting in data from third column...
    By pace0003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 02:12 PM
  5. Replies: 0
    Last Post: 06-14-2013, 01:36 PM
  6. Excel 2007 : Data from 3 columns into Fourth column
    By EsKay! in forum Excel General
    Replies: 1
    Last Post: 06-23-2011, 09:21 PM
  7. Replies: 5
    Last Post: 09-24-2009, 03:46 AM

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