Comparing a cell value with a range in a table and displaying a response

[Mark1975UK]

Hello, I am not sure if this is the best place to post this request, however, 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 of column AA in column M.

Any help would be appreciated.

Yours sincerely,

Mark.

[Pete_UK]

Without a sample workbook it's difficult to know the exact layout of your data, but try this in M2:

=VLOOKUP(L2,$Y$1:$AA$11,3)

assuming your score is in L2 and your table is in Y1:AA11 and is in increasing order of score.

Hope this helps.

Pete