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.
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.