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

M

Mark1975UK

Hello,

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

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

Any help would be appreciated.

Yours sincerely,

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Calculating an average of data between two dates 1
VBA help with selecting multiple data ranges 1
Can Text be Treated as Values for use in Calculations with Numbers? 3
X,Y,Z values to be extracted and posted respectively in excel 5
Macro for compare between 2 workbooks and copy adjacent cells 1
Excel formula help for calculating freight. 2
Lookup Y&X show Z but only in A & B are correct 1

Top