Abdulkhadar
Board Regular
- Joined
- Nov 10, 2013
- Messages
- 165
- Office Version
- 2019
- 2010
- Platform
- Windows
Hello Excel Experts,
I want to find the grade. first lookup the maximum no. from A column from first row, then lookup the column B value from the prescribed range.
<tbody>
</tbody>
My goal is
<tbody>
</tbody>
Thanks in advance
I want to find the grade. first lookup the maximum no. from A column from first row, then lookup the column B value from the prescribed range.
Maximum | 10 | 20 | 30 | 40 | 60 | 100 | ||||||||||||
RANGE | GRADE | RANGE | GRADE | RANGE | GRADE | RANGE | GRADE | RANGE | GRADE | RANGE | GRADE | |||||||
09 | 10 | A+ | 18 | 20 | A+ | 27 | 30 | A+ | 36 | 40 | A+ | 54 | 60 | A+ | 90 | 100 | A+ | |
07 | 08 | A | 14 | 17 | A | 21 | 26 | A | 28 | 35 | A | 42 | 53 | A | 70 | 89 | A | |
05 | 06 | B+ | 10 | 13 | B+ | 15 | 20 | B+ | 20 | 27 | B+ | 30 | 41 | B+ | 50 | 69 | B+ | |
03 | 04 | B | 06 | 9 | B | 09 | 14 | B | 12 | 19 | B | 18 | 29 | B | 30 | 49 | B | |
00 | 2 | C | 00 | 5 | C | 00 | 8 | C | 00 | 11 | C | 00 | 17 | C | 00 | 29 | C |
<tbody>
</tbody>
My goal is
A | B | C | |
1 | Maximum | Obt. Marks | Grade |
2 | 10 | 9 | A+ |
3 | 20 | 9 | B |
4 | 30 | 9 | B |
5 | 60 | 30 | B+ |
6 | 100 | 70 | A |
<tbody>
</tbody>
Thanks in advance