| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing a cell value with a range in a table and displaying a response
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a cell value to a range | Excel Worksheet Functions | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| comparing one to one cell within range | Excel Worksheet Functions | |||
| Displaying cell range with Vlookup | Excel Discussion (Misc queries) | |||
| I displaying a range in Time within a cell in Excel. | Excel Discussion (Misc queries) | |||
Threaded Mode
