+ Reply to Thread
Results 1 to 7 of 7

Formula to Return Multiple matches from a table

  1. #1
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Formula to Return Multiple matches from a table

    I am trying to find a formula that will return all that matches a column in a table. I found one that will return starting at the second row of the table on down if the criteria is met.. I need it to start at the first row if possible. I'm trying to stay away from VBA do to the fact that this file will be accessed a crossed multiple platforms (windows, android, mac)

    Here's what I got so far

    Please Login or Register  to view this content.
    thank you for your help
    original found on
    http://eimagine.com/how-to-return-mu...ch-or-vlookup/
    Bramz

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formula to Return Multiple matches from a table

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Formula to Return Multiple matches from a table

    Here is the Sample workbook

    Thank you for your help
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formula to Return Multiple matches from a table

    In A2, an array formula, copied down:

    =IFERROR(INDEX('Master List'!A:A,SMALL(IF(Table1[PAYING DUES?]="Yes",ROW(Table1[PAYING DUES?])),ROWS(A$2:A2))),"")
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Formula to Return Multiple matches from a table

    Hi

    the formula confirmed with control+shift+enter should do tre trick

    =IFERROR(INDEX('Master List'!A$2:A$100,SMALL(IF('Master List'!$J$2:$J$25="YES",ROW($2:$100)-ROW($A$2)+1),ROWS($1:1))),"")


    Regards

    Edit: ciao Glenn...
    Attached Files Attached Files
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  6. #6
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Formula to Return Multiple matches from a table

    Works like a Charm Thank you Both

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formula to Return Multiple matches from a table

    You're welcome.

+ Reply to Thread

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 Matches into Corresponding Table
    By QuantumP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2016, 04:37 AM
  2. Formula to return multiple matches within a range, ranked
    By chococ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2016, 07:52 AM
  3. Return defined number of matches in table
    By inq80 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2015, 06:43 PM
  4. Search a table with multiple search inputs and return all matches
    By JDI in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-16-2014, 12:23 PM
  5. Replies: 9
    Last Post: 07-03-2013, 07:39 AM
  6. [SOLVED] INDEX MATCH array formula that matches substring n gives multiple matches
    By bkwins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 04:57 AM
  7. find and return multiple matches in a table, then sum and report total
    By cyclops755 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2013, 06:57 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