Another way to do it:
=IF(AND(A1=0,A1<=45),"F",IF(AND(A1=45,A1<=49),"E ",IF(AND(A1=50,A1<=59),"D",IF(AND(A1=60,A1<=69), "C",IF(AND(A1=70,A1<=79),"B",IF(AND(A1=80,A1<=10 0),"A",IF(A1=101,"102+","grade")))))))

Paste this into the cell where you want the grade to appear, referencing the
cell where you type in the grade

Tom

"bimseun" wrote:

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