Spreadsheet Formulas

css navigation by Css3Menu.com

Calling All Teachers

You have scores for your students. You want the letter grade.

In this example, we compare the scores to a grid or array.
Grades Example
Make a VLOOKUP formula where the Number to Look at is first, then the address of the entire Array, then what column number to return. The Array must be sorted in alphabetical or numeric order.

© 2003-2016

Updated:  11/16/2016 19:50
This page added:  05 May 2003