Results 1 to 5 of 5

Trouble with indexing multiple criteria with a date range

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    14

    Trouble with indexing multiple criteria with a date range

    I am having trouble indexing a date that falls in a range and there is another criteria to match in order to get the result I want. Can someone help me with my formula? It is not selecting the correct information.

    {=INDEX(Rates2!$C$2:$F$37,MATCH($D10&$A10,Rates2!$C$2:$C$37&IF($A10>=Rates2!$E$2:$E$37,IF($A10<=Rates2!$F$2:$F$37,"")),1),MATCH("Timeframe",Rates2!$C$2:$F$2,))}
    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. Replies: 11
    Last Post: 02-07-2013, 02:22 AM
  2. Replies: 4
    Last Post: 12-06-2011, 03:01 PM
  3. Count - multiple criteria, multiple sheets, and date range.
    By threecliffs in forum Excel General
    Replies: 6
    Last Post: 06-14-2011, 01:36 PM
  4. sum multiple criteria date range
    By emitecaps in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-13-2010, 08:15 AM
  5. Indexing and matching multiple criteria
    By Dbeethekidd in forum Excel General
    Replies: 8
    Last Post: 09-02-2009, 08:22 AM

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