# multiple index and match

• hi Guys,

What I would like to do is match column 1, 2, 3 and 4 and get the points from lookup sheet which matches exactly to this.

## Files

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

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

## Participate now!

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