• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help on Index-Match Multiple Criteria with Time

Enya78

New Member
Hello,

Newbie here. I need some help with a multiple criteria index-match based on a reference table. Please check the attached file. Column D contains the current formula that will work with only 1 criteria. I tried using =INDEX(K:K,MATCH(1,(B4=I:I)*(C6>=K:K),0)) and used it as an array formula but it's not giving me the answers. I'm completely at a loss and needs your help badly to cleanse my data.

Thank you in advance.
 

Attachments

  • For Assistance_Index Match.xlsx
    11.6 KB · Views: 18
Back
Top