Searching a table, satisfying multiple criteria to display a value on a different sheet.

Hi Everyone,

I have a situation where I'm trying to work out class groups for students based on their English, Maths and Science scores.
I have made a table which explains the system, whereby a student's level (1,2 or 3) are considered and a group number is given.
i.e. Student 1001 scored level 1 in English, level 2 in Maths and level 3 in science, so therefore the system (table) shows that they should be placed in group 1 (see attached).
Essentially I have a matrix of numbers used for reference with three levels. And if certain conditions are satisfied, it gives out a different group number at the end.
It's important to say that there is no calculation involved at all. The system needs to just look at column a for a number, then column B, then column C and display the value that satisfies all those conditions.

Attached is an example of the system.
I know I haven't been completely clear in my post, ,however it should make sense when the attachment is viewed.

Class Set Sorting System.xlsx

**UPDATE**

I've now updated the attachment, it might make things a little clearer.

Class Set Sorting System.xlsx

I'm sure there are other / easier ways, but a simple sumifs formula should do the trick as well.

Let me know if you have any questions.

PS I got bored so I changed the colors up.

Oops - I forgot to lock the criteria cells in my previous formula. The attached fixes that problem. Alternatively you could put the data in to dynamic ranges to automatically update if / when you add more students.