Match and Index function with repeated values

Hey guys,

I am using a formula that tells you what kind of learning behaviour you have based on a score you receive after answering a bunch of questions. There are 3 behaviours. I have been using this formula: INDEX(Calculations!L20:L22,MATCH(MAX(D38:D40),D38:D40,0) as a part of my if statement to tell what kind of learner the person is. The only issue is that when they receive the same score for 2 of the behaviours, it only tells them they have one behaviour. Is there anyway I can change the function to make it so it says you are a ___ learner AND a ___ learner?

This is the entire formula if it helps to see it. The ISBLANK function is to make sure that they answer every question before seeing their associated behaviour.

=IF(OR(ISBLANK(K11), ISBLANK(K12), ISBLANK(K13), ISBLANK(K14), ISBLANK(K15), ISBLANK(K16), ISBLANK(K17), ISBLANK(K18), ISBLANK(K19), ISBLANK(K20), ISBLANK(K21), ISBLANK(K22), ISBLANK(K23), ISBLANK(K24), ISBLANK(K25), ISBLANK(K26), ISBLANK(K27), ISBLANK(K28), ISBLANK(K29), ISBLANK(K30), ISBLANK(K31), ISBLANK(K32), ISBLANK(K33), ISBLANK(K34)), " ", INDEX(Calculations!L20:L22,MATCH(MAX(D38:D40),D38:D40,0)))

Thanks for the help. I'll post more details if you need them.

Here is the sample book.Sample.xlsx

Originally Posted by Glenn Kennedy

Others might cope without seeing an example spreadsheet (no confidential data), but I can't!! can you post a suitable example, showing at least one case of an equal score against two cetegories?

Have any luck at it?

Thank you for your help. Looks like you made the calculation process a lot better too. How would I go upon placing Sheet1 into my workbook?

I was just testing out the spreadsheet again and I noticed that when just one of the options are the highest (for example visual learner is the dominant style), it still displays 'and a' underneath on Sheet1 and the Form. Any suggestions on how to fix this?

Works perfect now! Thanks