lookup_value = the cell with the test grade. (cell A2 in your example) table_array = the table from step 1. Highlight the entire thing. Col_index_num = 2. This will return the data from column 2 of ...