Grade 1 2 3, etc.
10,000 10,500 11,000
12,000 12,500 13,000
14,000 14,500 15,000
16,000 16,500 17,000
18,000 18,500 19,000
We have a worksheet that lists numbers in rows and columns. At the top of
each column is a number that represents a grade. What function would we use
to look up the value of a cell from another sheet, compare it to this table,
and return the column €œgrade€� number? Example, 12,500 should return grade 2.

Thank you for your time and cooperation.

S. Neese