Results 1 to 6 of 6

Use INDEX function to look for nth match

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2020
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9

    Use INDEX function to look for nth match

    Currently I am building an automated planning sheet which makes use of multiple worksheets. There is an overall sheet which pulls data from the project list based on the INDEX-MATCH formula.

    The problem now is, as I put two equal values (names) in the project lists beneath each other, it always pulls out the first match and does not look beyond that first match if first match is not correct for another correct match below the first given match. The match is based on the name and if it is in between the start- and end date of the given project.

    In the given Excel the problem is visualized. In sheet 'Projectenlijst', there's given two project for the first worker except within the sheet 'Overzichtsplanning' it only shows the first given match and not the second match.

    Is there any possible way for the INDEX-MATCH formula to continue searching until first found match is true?
    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. Replies: 7
    Last Post: 10-03-2019, 11:23 AM
  2. [SOLVED] Index/Match/Min/ABS Function needs to ignore one value in the index.
    By pronghorn in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-16-2019, 02:04 AM
  3. How to apply an Index.Match.Match function to all entries in a Listbox on a User Form
    By jason.drozd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2018, 01:54 AM
  4. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  5. Problems applying INDEX-MATCH-MATCH function on other data
    By LennartB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 05:33 AM
  6. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  7. Replies: 3
    Last Post: 06-17-2013, 12:37 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