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-2024

Updated:  01/23/2024 13:34
This page added:  05 May 2003