Results 1 to 17 of 17

INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2018
    Location
    London,England
    MS-Off Ver
    2016
    Posts
    18

    INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single cell

    As you know, using INDEX MATCH MATCH will only return the first result it finds in my range of data (B10:U29)
    I simply want to find a way to adjust my formula so all the occurrence appear in a single cell joined together with a comma

    Hoping someone here might be able to assist and offer up a little advice as to what it is I'm missing here. Thanks 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. nth occurrence with multiple criteria (index/match)
    By Hlech989 in forum Excel General
    Replies: 3
    Last Post: 03-08-2019, 03:46 AM
  2. Replies: 2
    Last Post: 03-07-2019, 07:29 PM
  3. Index match nth occurrence or just get nth match
    By sdl2 in forum Excel General
    Replies: 10
    Last Post: 05-21-2018, 09:59 AM
  4. Finding Second Occurrence if Index Match Returns -
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-22-2016, 02:50 PM
  5. Using index and match to return a value based on earliest occurrence (MONTH)
    By potatoman in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-09-2014, 06:12 AM
  6. Using index and match to return a value based on earliest occurrence (MONTH)
    By potatoman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2014, 06:16 AM
  7. [SOLVED] Index Match row value and nth occurrence of header
    By dm@stams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2013, 05:43 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