Results 1 to 5 of 5

Index match array return all matching values

Threaded View

Lameimpala Index match array return all... 07-01-2019, 01:22 PM
protonLeah Re: Index match array return... 07-01-2019, 06:24 PM
Lameimpala Definitely a broken leg!... 07-02-2019, 04:15 AM
AliGW Re: Index match array return... 07-02-2019, 04:17 AM
Lameimpala Re: Index match array return... 07-02-2019, 12:44 PM
  1. #1
    Registered User
    Join Date
    06-29-2019
    Location
    Montreal, Canada
    MS-Off Ver
    Office 365
    Posts
    5

    Index match array return all matching values

    I have this Index Match array formula that returns corresponding values from a matrix {=INDEX($A$2:$A$412,MATCH(1,MMULT(--($B$2:$R$412=A5),TRANSPOSE(COLUMN($B$2:$R$412)^0)),0))} which works fine, however it only returns the first matching value from the data and not all matching values, how could I amend it to return any and all matching values rather than just stopping at the first match. Oh, I also wanted to add and IFERROR of 'Not Found' but couldn't get the parentheses correct, but that isn't vital.

    Thanks
    Attached Files Attached Files
    Last edited by Lameimpala; 07-01-2019 at 04:09 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If range contains one of the values in the array, return the index of the array
    By LawCarrot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2018, 04:12 AM
  2. Replies: 2
    Last Post: 03-15-2017, 08:22 AM
  3. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  4. [SOLVED] Index and Match to return ALL matching values
    By garciapliz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-07-2015, 05:41 AM
  5. [SOLVED] Index/Match to Return 1D array to be used in a sumproduct
    By david0985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2014, 04:41 PM
  6. [SOLVED] Index/Match and return all matching values
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2014, 06:09 PM
  7. Use Index/Match Function to Return Values from an Array
    By 00pumpkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2013, 02:22 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