Scorecard table with ranged target scores

Hello, Bo_Ry.

Thanks for the help.

I just recently started using your formula/table and tried adjusting it to my data but it's somehow messing up. On the file attached, SAMPLE SHEET tab shows the desired "look" of the score table I'm trying to achieve while CURRENT FORMULA USED tab is where I used the formula you suggested but - if you'd look at the scores on that sheet - it's not showing the accurate scores.

I've been trying to work around this for days now (during my free time at work) but to no avail. I hope you can help me once again with this.

Thank you.