Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=LOOKUP(A4,{0,70,73,77,80,83,87,90,93,97},{F,D+,C-,C,C+,B-,B,B+,A-,A,A+})

=LOOKUP(A4,{0,70,73,77,80,83,87,90,93,97},{"F","D+","C-","C","C+","B-","B","B+","A-","A","A+"}) looks up the value in A4 in the first row of the array, finds the largest value that is less than or equal to it, and then returns the value in the last row that's in the same column Input the formula: =LOOKUP(A4,{0,70,73,77,80,83,87,90,93,97},{"F","D+","C-","C","C+","B-","B","B+","A-","A","A+"}). Press Enter to get the result.