+ Reply to Thread
Results 1 to 6 of 6

Take column data from one sheet to another based on unique identifier

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    3

    Take column data from one sheet to another based on unique identifier

    Hello. I need some help. This is probably a vlookup issue? Thank you in advance.

    What I need to do:
    I've got two worksheets, each with a column that is an email address.
    Worksheet 1 is a list of orders. Worksheet 2 is an email contact list with a version number that I want to display in Worksheet 1. (Ex. Email Address ABC in Worksheet 1 would show "Version A" coming in from the appropriate column in Worksheet 2. I want to see which orders came from the various versions.) Caveat: Worksheet 1 will have multiple instances of the email address if there were multiple orders, while Worksheet 2 has the email address only once.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Take column data from one sheet to another based on unique identifier

    Hi Mogogo,

    Welcome to the forum.

    Ok.. so do you need multiple results using vlookup?
    suggest you to upload a sample file. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    04-12-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Take column data from one sheet to another based on unique identifier

    Thanks for your quick response, dilipandey. I have uploaded a sample file of what I want to do. I'm looking to get the Version column from the second sheet to populate on the first sheet in a new column.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Take column data from one sheet to another based on unique identifier

    Hi mogogo,

    See the attached file and let me know if this helps.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-12-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Take column data from one sheet to another based on unique identifier

    Awesome. That did the trick. Thanks so much for your help!

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Take column data from one sheet to another based on unique identifier

    You are welcome mogogo...

    Regards,
    DILIPandey


    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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