+ Reply to Thread
Results 1 to 4 of 4

Index Matching with a nested Greater than function for multiple criteria

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Index Matching with a nested Greater than function for multiple criteria

    SAMPLE.xlsx

    I am trying to get the rate for members that meet four criteria in column E from the rate table tab.

    The current columns and criteria are:
    A B C D
    Cnty *** Age Group

    The problem I'm having is using an Index Match formula I can't get anything that works for the age minimum and age maximum in the rate table; for instance Males between 6 and 18, and how do I get it to index the Group columns in the rate table. I have attached a sample file that illustrates it better.
    Last edited by Solpics; 12-04-2012 at 09:58 PM. Reason: my column name was changed

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Index Matching with a nested Greater than function for multiple criteria

    In E2: =SUMPRODUCT((RateTable!A$2:A$23=A2)*(RateTable!B$2:B$23=B2)*(RateTable!C$2:C$23<=C2)*(RateTable!D$2:D$23>=C2)*(RateTable!E$1:H$1=D2)*RateTable!E$2:H$23)

    copy down

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Index Matching with a nested Greater than function for multiple criteria

    Thanks Teethless that worked. Now I'll have to go through the formula to see how.

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Index Matching with a nested Greater than function for multiple criteria

    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)

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