+ Reply to Thread
Results 1 to 4 of 4

Index Match using two sheets for Criteria to Match

  1. #1
    Registered User
    Join Date
    05-22-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    47

    Question Index Match using two sheets for Criteria to Match

    I am currently working on a file and would like to use match index but the criteria's are located into separated sheets ( unfortunately these two sheets cannot be placed into one ), any help on this please?

    Basically I need an index match that pulls information that are located into two separate sheets.
    Last edited by Locust; 11-28-2013 at 06:49 PM. Reason: clarify

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Index Match using two sheets for Criteria to Match

    Is the info for the criteria always in a known location, or do you need to search for that too?

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-22-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Index Match using two sheets for Criteria to Match

    Unfortunately my office web is not allowing me to attach/download anything however if you can picture the scenario where:

    I need to see the employee names on Sheet2 B3-B500 if

    MATCH values from Sheet 2

    A3-A500 - dates
    C3-C500 - department



    On Sheet 1 - names from Sheet 2 are to be displayed in Sheet 1 A3-A10

    Look Up values from Sheet1 are
    A1 - Date
    A2 - Department
    Last edited by Locust; 12-01-2013 at 12:45 PM.

  4. #4
    Registered User
    Join Date
    05-22-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Index Match using two sheets for Criteria to Match

    any help and solution to this please?

+ 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. Index and Match with Two Criteria, and date Match Type is Less Than
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-11-2013, 08:57 AM
  2. Replies: 10
    Last Post: 12-18-2012, 07:59 AM
  3. Index Match based on 2 Criteria only returning 1 match
    By stsanders22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 11:26 PM
  4. [SOLVED] Index/Match Not Matching Correctly on Multiple Criteria Across Sheets
    By cbauer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2012, 04:19 PM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 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