+ Reply to Thread
Results 1 to 6 of 6

Array Filtering for Lists Using Index Match

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Cool Array Filtering for Lists Using Index Match

    I have a pretty good formula to select data based on one criteria. I would like to add a second criteria to my list.

    {=INDEX($I:$I,SMALL(IF($L:$L=$B$2,ROW(I:I)+0),ROW(I1)))}

    I use this formula to reference $B$2 which limits my results. I want to add another criteria and use $B$2 and $C$2 to limit results.

    Please see attached.


    Array Formula Multiple Criteria.xlsx

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Array Filtering for Lists Using Index Match

    This should do it for you though I don't recommend using whole column references.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Array Filtering for Lists Using Index Match

    I appreciate it sir.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Array Filtering for Lists Using Index Match

    Here is a much more "robust" formula with limited column ranges.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Array Filtering for Lists Using Index Match

    I hope that solves your problem.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  6. #6
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Array Filtering for Lists Using Index Match

    Thanks again.

+ 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. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  2. Problems with cell referencing after filtering and index/match
    By fgcampjr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-09-2014, 06:24 PM
  3. [SOLVED] Help with dependent lists INDEX MATCH
    By jet2004uk in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-19-2012, 12:00 PM
  4. Index Match array equation with sub-array calculation
    By glebbo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 03:04 AM
  5. Excel 2007 : Index Function Array Filtering
    By RowanB in forum Excel General
    Replies: 2
    Last Post: 02-26-2010, 12:08 PM

Tags for this Thread

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