Index match multiple criterias

Hi everyone,

Thank you for taking the time to read this post, I appreciate any feedback that will guide me into the right direction.
I am attaching a spreadsheet, based on multiple criterias probably using index/match , but only wish to insert a score and hope this will give a corresponding grade. Please see the sheet for an example.

Many Thanks

Try this in J4

Formula:

Please Login or Register  to view this content.

That should do the trick.

That worked brilliantly, thank you for the quick turn around I really appreciate your help Quekbc.

Not a problem salimnore. If this resolves your problem, can you please mark this thread as solved? You can do so by clicking on Thread Tools above your first post and then Mark This Thread as Solved.