Hello,

I am trying to produce a spreadsheet for monitoring of marks and current grades of students. I have got to the point where I have two tables in a spreadsheet. In one the current score is generated (column L) and in the second the range for a grade (lower value in column Y, upper value in column Z) is shown along with the grade (column AA). There are 11 possible grades with ranges.

I was wondering if it is possible for EXCEL to take the mark from column L, compare it with the values in columns Y and Z and finally place the corresponding value in column AA in column M.

Any help would be appreciated.

Yours sincerely,

Mark.