Results 1 to 3 of 3

Thread: Index Match return wrong result

  1. #1
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013

    Question Index Match return wrong result



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can someone help
    I created a Array formula
    Code:
    =INDEX($C$2:$C$6;MATCH(E15;YEAR($A$2:$A$6);0);MATCH(E16;$B$2:$B$6;0))
    But the formula returns an incorrect result if I change one of the conditions
    Please see attachment
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =INDEX($C$2:$C$6,MATCH(1,INDEX((YEAR($A$2:$A$6)=E15)*($B$2:$B$6=E16),0),0))

    This does not need to be confirmed with CTRL+SHIFT+ENTER.. Just ENTER will work.


  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Thank @NBVC

    [SOLVED]
    Last edited by NBVC; 2015-02-03 at 09:23 PM. Reason: corrected spelling of my name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •