v lookup
finde class and grade using following table
| AVG | CLASS | GRADE |
| 25 | SECOND | F |
| 30 | SECOND | D |
| 35 | SECOND | D+ |
| 40 | SECOND | D++ |
| 45 | SECOND | C |
| 50 | SECOND | C+ |
| 55 | SECOND | C++ |
| 60 | FIRST | B |
| 65 | FIRST | B+ |
| 70 | FIRST | B++ |
| 75 | FIRST | A |
| 80 | FIRST | A+ |
| 90 | FIRST | A++ |
| VLOOKUP | | | | | | | | | | | |
| SR | NAME | M1 | M2 | M3 | M4 | M5 | M6 | TOTAL | | AVG | GRADE | class | grade |
| 1002 | sanju | 25 | 25 | 25 | 25 | 25 | 25 | 150 | | 25 | F | | |
| 1003 | dada | 45 | 89 | 99 | 56 | 65 | 98 | 452 | | 75.33333 | A | | |
| 1004 | asmita | 89 | 58 | 58 | 89 | 98 | 98 | 490 | | 81.66667 | A+ | | |
| 1005 | kajal | 59 | 95 | 59 | 78 | 35 | 65 | 391 | | 65.16667 | B+ | | |
| 1006 | sanju | 59 | 78 | 56 | 48 | 89 | 98 | 428 | | 71.33333 | B++ | | |
| 1007 | mangesh | 58 | 48 | 98 | 49 | 52 | 68 | 373 | | 62.16667 | B | | |
| 1008 | lina | 58 | 49 | 58 | 45 | 89 | 68 | 367 | | 61.16667 | B | | |
| 1009 | dada | 58 | 78 | 27 | 78 | 68 | 56 | 365 | | 60.83333 | B | | |
| 1010 | sanju | 65 | 96 | 59 | 89 | 45 | 58 | 412 | | 68.66667 | B+ | | |