Formula for multi-column table to determine levels of certification

I'm working on a spreadsheet that professionals will use to track their progress in reaching fidelity to practices. There are three levels: no fidelity, approaching fidelity, and fidelity. Within one section, there are three separate characteristics that the professional must exhibit in their practices in order to achieve fidelity. They may do really well in one, but not great in another. I have a table that shows the various stages with each characteristic and how that translates to overall fidelity for that section. I need to know how to use the table to translate their progress on a summary worksheet.

The example I'm attaching has two worksheets, the summary and the detailed one. There are already formulas embedded to keep cells blank until filled and to calculate individual fidelity status. I just don't know how to use the table to write a formula that takes into consideration 27 different combinations that can result in three different progress levels.

Thanks for your help!

L

Assuming results are in "Total" row of "Section 7"

Create helper column as shown in column M

=H2&I2&J2

in "Summary"

B2

=IFERROR(INDEX('SECTION 7'!$K$2:$K$10,MATCH('SECTION 7'!$B$8&'SECTION 7'!$C$8&'SECTION 7'!$D$8,'SECTION 7'!$M$2:$M$10,0)),"No Match")

There were formulas already in the individual sections. When I tried to change John's formula to work with it, it still says no match. The results need to say the full words in caps to match the other sections: FIDELITY, APPROACHING FIDELITY, NO FIDELITY. I have attached the file with part of it filled out so you can see how it works so far. You can play with the yes/no in the columns and it will change fidelity status in each. I think your solutions still work, I'm just not sure how to tweak them. I'm sorry I wasn't clearer in my first post.

I see nothing filled in in "Section 7"

I'm not sure what happened. When I downloaded it, it said it had to be repaired. I've attached it again if you still want to look at it.