multiple index and match

  • Re: multiple index and match


    What if there is more than one exact match?


    This formula assumes there is one exact match, and if there is more than one match it will give sum of scores...


    [COLOR="#0000FF"]=SUMIFS('Lookup Table'!$E$2:$E$9,'Lookup Table'!$A$2:$A$9,B2,'Lookup Table'!$B$2:$B$9,C2,'Lookup Table'!$C$2:$C$9,D2,'Lookup Table'!$D$2:$D$9,E2)[/COLOR]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: multiple index and match


    Hello,


    My assumption is that you have different points for each Unique combination of four answers ...


    Hope attached workbook will help ...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!