+ Reply to Thread
Results 1 to 3 of 3

Index match with 3 criteria not working

  1. #1
    Forum Contributor
    Join Date
    10-08-2014
    Location
    Bengaluru, India
    MS-Off Ver
    O 365
    Posts
    141

    Index match with 3 criteria not working

    Hi all;
    I have a 3 criteria, Date, Project name and Plan/Achd. quantity for the day. i have given a formula like this
    =INDEX($C$3:$N$12,MATCH($C18,$A$3:$A$12,0),MATCH($B$18,$C$1:$N$1,0),MATCH($B$4,$B$3:$B$12,0))

    it is working for only plan column , where as for achieved it is not working. please help
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Index match with 3 criteria not working

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-08-2014
    Location
    Bengaluru, India
    MS-Off Ver
    O 365
    Posts
    141

    Re: Index match with 3 criteria not working

    Quote Originally Posted by tim201110 View Post
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    yes its working.
    can u just tellme what did you do.. what is the use of adding +1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Single Criteria Index Match with concatenated criteria NOT WORKING
    By hassanleo1987 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-26-2017, 12:28 AM
  2. [SOLVED] Use Index/Match to return a value based on two criteria? Not working for me...
    By ralldredge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2015, 02:42 PM
  3. [SOLVED] Lookup with mutiple criteria - Vlookup, Match, index not working
    By PM1985 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-17-2014, 07:10 AM
  4. [SOLVED] Index and Match for 4 Criteria - My 2 attempts are not working
    By denise001 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-05-2013, 01:55 PM
  5. [SOLVED] Index Match Multiple Criteria not working
    By garciapliz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2013, 12:07 PM
  6. [SOLVED] INDEX/MATCH not working for multiple criteria
    By lukesanborn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-27-2012, 09:20 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