Results 1 to 4 of 4

Index Match with mutliple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Index Match with mutliple criteria

    I'm working on a formula to pull a "Fee" from a fee schedule based on user-input "Insurance Company" and "GCA".

    So far, I've tried dozens of syntax options for a few hours today and this is the closest I can get "{=INDEX(D2:D31,MATCH(F6,A2:A31,0),MATCH(G6,B2:B31,-1),MATCH(G6,C2:C31,1))}" but it is showing errors too.

    I'm trying to...

    Find F6 in column A2:A31
    Find the number in B2:B31 that is less than G6
    Find the number in C2:C31 that is greater than G6
    Return the corresponding cell's value from D2:D31

    Can anyone get me closer?

    I have lot's of crazy formulas and do lot's of weird stuff, so I'll be happy to help others where I can now that I'm a member...unfortunately, right now I'm the one who is stuck!

    Thanks in advance, Stephen
    Attached Files Attached Files
    Last edited by FunctionalHippie; 08-29-2012 at 01:45 PM. Reason: Solved

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