| Lookup table - Name = Grades | |||||||||
| 1. Set up table | |||||||||
| 2. Use insert, name to name the table | |||||||||
| 3. Write lookup. | =LOOKUP(value,chart, offset) | ||||||||
| Lookup the following | |||||||||
| Points | Grade | Comment | Grades based on points: | ||||||
| 0 | F- | Very Bad | 450 | F- | =VLOOKUP(B16,grades,2) | ||||
| 500 | F | Very Bad | 798 | C | =VLOOKUP(C16,grades,2) | ||||
| 600 | D | Bad | 825 | B | =VLOOKUP(D16,grades,2) | ||||
| 700 | C | Passing | 925 | A | =VLOOKUP(F16,grades,2) | ||||
| 800 | B | Good | 1000 | A | =VLOOKUP(F16,grades,2) | ||||
| 900 | A | Very Good | |||||||
| 1000 | A | Excellent | Comments based on grade: | ||||||
| 450 | Very Bad | =VLOOKUP(B22,grades,3) | |||||||
| 798 | Passing | ||||||||
| 825 | Good | ||||||||
| 925 | Very Good | ||||||||
| 1000 | Excellent | ||||||||