Lowest average of student and return student name

Here are 3 working options for you to choose from. You need to remember that INDEX works with SHEET row numbers. So if you use anthing OTHER than a form that uses the range starting from B1 (such as B1:Bxxx, or B:B) then you need to add in a couple of terms to correct.