I have a worksheet where using a table and vlookup, I enter a student's ID
number, and get their name. Then, using a nested IF statement I convert
their grade (0-100) into a letter grade (A-F).

let's say that the student's ID and score are entered in cells C2 and C3
respectively.

I would like that letter grade to then populate a table and save the grade.
Currently, when I enter the next ID and grade the previous one goes blank and
the new value is entered in the next cell.