Spreadsheet Formulas

Calling All Teachers

In this example, we compare the scores to a grid or array.

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.