Using the vlookup function (exact)
Viewing tip: Press the 'Play' button, and then the 'Fullscreen' button on the right.
Vlookup Tutorial For Beginners
This video shows how to use Excel's vlookup to fill in data for you:
You will enter the student's score, and the spreadsheet will automatically fill in the corresponding letter grade for this score (for Example 70 will give the letter "C" letter), and the corresponding verbal description (in our example: "Below average").
How will vlookup know how to do it? Well, it will take the score you enter, and will look it up in a table, and retrieve the value that is written there next to it.
In our first example, it will look for the value 70 in the table, and will retrieve the letter C which is in the 2nd column in the table.