Results 1 to 4 of 4

Index Match - multiple criteria & multiple matches

Threaded View

suwandy Index Match - multiple... 12-03-2013, 12:43 AM
benishiryo Re: Index Match - multiple... 12-03-2013, 12:51 AM
suwandy Re: Index Match - multiple... 12-03-2013, 01:06 AM
benishiryo Re: Index Match - multiple... 12-03-2013, 10:16 PM
  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Index Match - multiple criteria & multiple matches

    Hi, I would like to extract Bill cost from "rule" sheet and insert it to "data" sheet using index-match functions. My problem are multiple criteria and multiple matches.

    The criteria are Column: Cost type, Power, Penalty Category (The logic goes like AND function).
    And i want it to extract "Bills" value from "rule" sheet.

    There are multiple matches in all columns (Cost type, Power, Penalty Category) which cause wrong extraction.

    How do i solve this problem with index-match function? or, any other function to solve this problem?
    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. Index/Match multiple sheets multiple matches
    By matt1971 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2013, 06:49 AM
  2. [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
  3. Replies: 4
    Last Post: 07-18-2012, 02:34 PM
  4. Index Match Problem for multiple matches
    By Coldsteel in forum Excel General
    Replies: 3
    Last Post: 09-13-2010, 10:29 AM
  5. Multiple Matches - Index/Match
    By brdwlsh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2007, 12:00 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