Results 1 to 11 of 11

How to index and match multiple criteria without repeating results?

Threaded View

PistachioPedro How to index and match... 11-19-2013, 04:26 PM
RobertMika Re: How to index and match... 11-19-2013, 05:30 PM
PistachioPedro Re: How to index and match... 11-19-2013, 06:22 PM
RobertMika Re: How to index and match... 11-19-2013, 06:24 PM
deevan Re: How to index and match... 11-19-2013, 06:29 PM
deevan Re: How to index and match... 11-19-2013, 06:32 PM
RobertMika Re: How to index and match... 11-19-2013, 06:35 PM
PistachioPedro Re: How to index and match... 11-20-2013, 03:40 PM
RobertMika Re: How to index and match... 11-20-2013, 05:17 PM
PistachioPedro Re: How to index and match... 11-20-2013, 05:35 PM
RobertMika Re: How to index and match... 11-20-2013, 05:38 PM
  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2016
    Posts
    56

    How to index and match multiple criteria without repeating results?

    Hello! This is really difficult to explain so it's best to look at the sample worksheet. I'm attempting to match 2 sport team's head-to-head results from a list of results, but I can only figure out how to match the most recent game they played against each other.

    These are the steps I'm hoping to recreate:

    - Input Team1's name in I1, and the Team2's name in L1
    - It should then find all the instances where in the results section, Team1 & Team2 appear together in columns B & D (In any order)
    - It should return the most recent game first, then find the second to most recent game and return that in the following row and continue

    The only way I know how to do this is to match Team1 & Team2 and return the most recent game, how can I make it continue down?

    Please look at the attached sample so it hopefully makes more sense. On the left is a replica of how my results columns are formatted, and on the right is what I am trying to achieve.

    Thank you all in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Returning multiple distinct/repeating values for vlookup or index-match
    By amatvien in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-21-2018, 01:14 PM
  2. [SOLVED] Index, Match, Multiple Results
    By ecorf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2013, 11:37 AM
  3. Index/Match with multiple results
    By kwadjo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2013, 04:05 PM
  4. Index/Match with multiple results
    By amcghee1 in forum Excel General
    Replies: 4
    Last Post: 10-18-2012, 12:15 PM
  5. Replies: 0
    Last Post: 03-02-2012, 11:16 AM

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