I have 38 names on my spread sheet and they took 3 tests, i need to pick out which student got the greatest test grade on each test and have their name and grade posted in two seperate cells. i was wonder if it is possible for me to use a function such as: =Lookup(C2:C38.....) to look up all the grades in my c column(test1) but i dont know how to tell it to pick out the greatest number. I also am confused on how to tell it to print the students name once i have found the greatest test grade. plz and thank you for any help