To do this, I will type the following formula into cell H2 ... Since the student hasn't yet reached the threshold for grade B (70), I need Excel to take the next smallest value in the lookup ...