+ Reply to Thread
Results 1 to 4 of 4

Match Multiple Columns from Separate Sheet to get separate column.

  1. #1
    Registered User
    Join Date
    05-19-2014
    Location
    San Diego, CA
    MS-Off Ver
    16
    Posts
    2

    Question Match Multiple Columns from Separate Sheet to get separate column.

    Hello,

    I'm sure there is a simple solution, so I hope I am clear in my explanation.

    I have a workbook with a Data sheet that will have info pasted into it from another source every quarter or so. I want to create a table in a different sheet that matches two columns from the data sheet. If both columns match, then I want data from a separate column. I want to check two columns (first name & last name) to prevent incorrect information.

    I have attached a small example.

    Sheet 2, A12 & B12 will have data typed manually. I want to check sheet 1, column B for last name AND sheet 1 column C for last name. If they both match, enter Column E(Teacher) in Sheet 2 Column 3.

    Forum Example.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Match Multiple Columns from Separate Sheet to get separate column.

    With an helpcolum.

    See the attached file.

    The result is in the green cells.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-19-2014
    Location
    San Diego, CA
    MS-Off Ver
    16
    Posts
    2

    Re: Match Multiple Columns from Separate Sheet to get separate column.

    Excellent!

    Thank you. What would you call this situation? A typical INDEX MATCH formula with a helper column? It seems so simple now that I see it.

    I will return,

    Thanks again,

    Gabriel Vitoro

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Match Multiple Columns from Separate Sheet to get separate column.

    Please Login or Register  to view this content.
    Yes,

    Thanks for the reply.

    Glad I could help

+ 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: 6
    Last Post: 11-29-2013, 10:52 PM
  2. [SOLVED] How to separate csv from a single column to multiple columns
    By gmckenna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2012, 12:51 PM
  3. Replies: 3
    Last Post: 06-12-2012, 01:33 PM
  4. Replies: 1
    Last Post: 01-12-2012, 07:50 PM
  5. Indexing multiple columns to return a result from a separate column
    By janjan_376 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2009, 03:14 PM

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