Results 1 to 3 of 3

Issue: Only returning 1st match on Index/Match

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    Montgomery, PA
    MS-Off Ver
    2013
    Posts
    1

    Issue: Only returning 1st match on Index/Match

    Hi Guys,

    I have a bunch of unique identification numbers and the ID numbers cannot be used more than once.

    ID number eligibility is determined by the index/match function (4 criteria). (formula works up to this point)
    {=INDEX(Table!$A$4:$AT$80,MATCH(1,(Table!$K$4:$K$80=K11)*(Table!$AT$4:$AT$80=M11)*(Table!$N$4:$N$80=O11)*(Table!$AQ$4:$AQ$80='1st result fail'!B11),0),1)}

    Where the formula falls apart is that it will only return the first ID number that meets the criteria. I need it to return a unique ID number that meets the index/match function criteria each time.

    Any ideas?

    Sincerely,
    Taylor
    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] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  2. Issue using Index/Match to pull multiple occurrences of "Match" criteria
    By aridfriedman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 11:38 AM
  3. Index Match based on 2 Criteria only returning 1 match
    By stsanders22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 11:26 PM
  4. [SOLVED] index match match - issue
    By jw01 in forum Excel General
    Replies: 2
    Last Post: 11-27-2012, 03:53 PM
  5. [SOLVED] Index & Match returning incorrect value. Arrays fixed and exact match used.
    By SDes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 08:29 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