Assume your grading scale was in the range A1:B6. Sort the numbers in ascending order:
0 F
45 E
50 D
....
80 A

If the overall average was in cell C1, then use:
=VLOOKUP(C1,A1:B6,2)

This looks for the value in cell C1 in the first (numbers) colum of the grade table, and returns the letter grade from the second column. If the exact value is not found, it will default to the next lowest letter grade. Ajust the ranges to fit.

--

"bimseun" wrote in message ...
Hi,
please I need guidance in using Vlook to output grade of students this
=80 A
70-79 B
60-69 C
50-59 D
45-49 E
<45 F
thanks,
bimseun