Results 1 to 7 of 7

Index/Match with Multiple Criteria and Multiple return values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    266

    Index/Match with Multiple Criteria and Multiple return values

    See attached workbook. Formula begins in cell F2 on down. Basically, it uses INDEX/MATCH to return a claim number from Group 2 where Group 1 has a date that falls between the Group 2 dates. It works fine to return one value, but, in instances of where I have multiple matching values, how do I return them both? (or even more)?

    Can they be concatenated in the same cell separated by comma, or placed in the next cell over? Either way I am fine with. Thanks.
    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. [SOLVED] Return Multiple values from a column with index and match, and search criteria
    By marcusduton in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-15-2015, 09:59 PM
  2. Replies: 0
    Last Post: 07-08-2014, 09:51 AM
  3. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  4. SOS:Return multiple values against multi criteria match and index function
    By nitesh_inin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2012, 05:45 PM
  5. Replies: 3
    Last Post: 06-15-2012, 04:19 PM
  6. [SOLVED] Return a value:index/match against multiple criteria on another sheet
    By Southfish in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 11:08 PM
  7. [SOLVED] How to use Index Match to return multiple values
    By pingpoeng in forum Excel General
    Replies: 2
    Last Post: 04-09-2012, 09:58 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