Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table.

The structure of the funtion is

VLOOKUP(lookup_value,table_array,col_index_num)

where

lookup_value - is the test score you have generated, you can either put the actual value into the function or use the cell address of the value.

table_array - is the sorted table of test scores and their grades. It may look like the table that follows

0 U 25 E 50 D 60 C 70 B 80 A 90 A*

The col_index_num - in this example would be 2, as the first column contains the test scores and the second the grade boundaries.