Solved

# VLOOKUP Excel 2010

Posted on 2011-10-29

Hi,

I need your help to complete the VLOOKUP formula for my sister who grading her students. I need to assign letter grades base upon points.

The points for the course is 600

To earn an "A", the student must have 540 or more points.

To earn a "B", the student must have 480 - 539 points.

To earn a "C", the student must have 420 - 479 points.

To earn a "D", the student must have 360 - 419 points.

Less than 360 points, earns an "F".

Student Total Points Grade

Mary 550

Sue 479

Paulo 200

Rena 420

Stanford 366

**Grade Table **