+ Reply to Thread
Results 1 to 2 of 2

How to use a multiple criteria index search with to find all matches

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    Los Angeles, CA
    MS-Off Ver
    2007
    Posts
    1

    Question How to use a multiple criteria index search with to find all matches

    Hello!

    I need help producing multiple matches from an index match search using more than one lookup value. For example, can I do an index search using DWP_Water and Harbor to produce both of the contacts that fall under this match? Hopefully I am making some sense.

    Thanks for your help!

    Capture.PNG

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: How to use a multiple criteria index search with to find all matches

    Hi bossmanamr. Welcome to the forum.

    It is helpful to upload an actual Excel workbook with "sanitized" data that illustrates your question.

    Pictures are unreadable for many of us and it saves having to retype data.
    Dave

+ 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: 5
    Last Post: 09-01-2014, 08:05 AM
  2. [SOLVED] What formulas can I use to find matches based on multiple criteria
    By Jonathan68 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2014, 02:22 PM
  3. [SOLVED] Index Match - multiple criteria & multiple matches
    By suwandy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 10:16 PM
  4. Find unique matches for multiple criteria within a row of cells
    By Chase in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2012, 03:11 PM
  5. Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  6. Replies: 8
    Last Post: 02-15-2012, 05:05 AM
  7. Find Value If Multi Criteria Matches Index
    By exc4libur in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2011, 09:05 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