+ Reply to Thread
Results 1 to 4 of 4

Need to match information in Sheet 2 with Sheet 1 and fill in the matching cell informatio

  1. #1
    Registered User
    Join Date
    12-10-2015
    Location
    Boston, MA
    MS-Off Ver
    version 8
    Posts
    2

    Need to match information in Sheet 2 with Sheet 1 and fill in the matching cell informatio

    Hello. Currently I have a worksheet that lists multiple investors in column C. I have in Sheet 2 a shorter list of matching investors and their relevant information. I need to match the investors in these two sheets and fill in the blanks.

    For example below - I need to fill in Sheet one with information from sheet two if an investor matches


    Data Matching_12.10.15.xlsx

    The investors in yellow in sheet 1 are the ones that match with sheet 2

    Thank You!
    Last edited by MeredithK79; 12-10-2015 at 01:55 PM.

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    935

    Re: Need to match information in Sheet 2 with Sheet 1 and fill in the matching cell inform

    is this what you need?Data Matching_answer.xlsx

  3. #3
    Registered User
    Join Date
    12-10-2015
    Location
    Boston, MA
    MS-Off Ver
    version 8
    Posts
    2

    Re: Need to match information in Sheet 2 with Sheet 1 and fill in the matching cell inform

    Yes thank you!!!!

  4. #4
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    935

    Re: Need to match information in Sheet 2 with Sheet 1 and fill in the matching cell inform

    you're welcome

+ 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. Replies: 19
    Last Post: 12-05-2015, 09:52 PM
  2. Look for matching information from two columns in one sheet, in another sheet
    By philmurp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2014, 03:18 PM
  3. Matching information from a product feed and importing it into another excel sheet
    By SinksUS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2013, 08:36 PM
  4. look up on sheet 1 match data sheet 2 and fill in cell on first sheet
    By treborharris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2013, 01:01 PM
  5. Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  6. [SOLVED] URGENT Pls help - Copying information from sheet 1 to sheet 2 base on a match of a value
    By 5er3ne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 08:39 AM
  7. Fill-in information from Excel sheet to a Website
    By nquadr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 03:45 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