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<=100),"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
>