+ Reply to Thread
Results 1 to 5 of 5

How to cross referencing two lists and copying relevant information

  1. #1
    Registered User
    Join Date
    06-06-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to cross referencing two lists and copying relevant information

    Hi there. I am having a problem with cross-referencing two sheets and attaining information that appears on both.

    I am compiling a master list of people for an organization. Let us call this Master List Sheet 1. However, it is not yet complete and needs information from another list we will call Sheet 2. I need Excel to search Sheet 2's list of people for individuals appearing in Sheet 1. If a person appears in both, then I want to copy the important information such as phone number, address, email, etc into the respective columns in Sheet 1. If you need any further information, just ask. Thanks!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How to cross referencing two lists and copying relevant information

    Hello,

    Looks like VLOOKUP would work. Could you please attach a dummy file?
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    06-06-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to cross referencing two lists and copying relevant information

    ok this is the dummy file
    Attached Files Attached Files
    Last edited by Zoraxe; 06-06-2011 at 02:51 PM.

  4. #4
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: How to cross referencing two lists and copying relevant information

    See the attached.

    Does this help?

  5. #5
    Registered User
    Join Date
    04-11-2011
    Location
    Texas
    MS-Off Ver
    Office 2007
    Posts
    78

    Re: How to cross referencing two lists and copying relevant information

    Haseeb, after seeing your example I'm afraid I interpreted the question wrong but I will post mine just the same. I also made this before Zoraxe posted an example so it's just some made up data according my reading of the question.

    Anyway, Sheet 1 and 2 have the personnel list. Worksheet finds the duplicates from Sheet 1 and 2 and then labels their row on Worksheet. Finally, Master Sheet pulls from the list on Worksheet and removes the spaces using the row numbers next to the names. The Phone Number and Addresses use the VLookup function to pull from Sheet 1.
    Attached Files Attached Files

+ 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