Results 1 to 5 of 5

help with index/match with multiple criterias alongwith dates !

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2010
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    Excel 2013
    Posts
    135

    help with index/match with multiple criterias alongwith dates !

    hi to all experts,,,

    here I am trying to develop a formula with the help of Index & match that criteria of Sheet matches with the criteria of sheet Data as follows :

    I want a formula at sheet name "Result" at cell "B5" if the "B3", "B4" & "A5" matches the value of Data sheet then I should get result as 5 and follows the other cells too.

    to define this formula I tried an array with index but could not work it seems.

    =+INDEX(Data!$C$3:$R$20,MATCH(1,(Result!B4=Data!$B$3:$B$20)*(Result!B3=Data!$A$3:$A$20)*(Result!A5=Data!$C$2:$R$2),0))

    for reference i attached the example sheet.

    thanks in advance.....
    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: 3
    Last Post: 11-17-2018, 02:37 PM
  2. Replies: 6
    Last Post: 02-23-2018, 07:09 PM
  3. [SOLVED] INDEX MATCH with OR multiple criterias
    By Dahlia in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-24-2017, 11:26 AM
  4. [SOLVED] Index match multiple criterias
    By salimnore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2015, 07:24 PM
  5. [SOLVED] Index-Match-(or Vlookup) for Multiple criterias.
    By Anatawan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 02:38 AM
  6. [SOLVED] INDEX & MATCH w multiple criterias?
    By Eemmai in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2012, 05:20 AM
  7. index match based on multiple criterias
    By jw01 in forum Excel General
    Replies: 4
    Last Post: 09-13-2011, 02:21 PM

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