How to convert score into grade??

This is an important trick, using LOOKUP and TEXTJOIN; we can produce this awesome sentence down including the student name/ his score/ and his grade

How to make a list or sentence from different cells??

 TEXTJOIN function doing great job on this regard, check this example; we joined 3 cells in one sentence. with the same logic you can make a list from a group of cells.

TEXTJOIN()