"rfryan61" wrote
.. The range actually is continuous. Let me see if I can explain things a
little better. There has already been a calculation done that tells us if
a
product fall between a specific range, it gets a specific "grade." For
example, if it falls between 0.0-0.4, it gets a grade of 5. And if it
falls
between 0.41-1.25, it gets a grade of 4.5. The ranges are continuous:
0.0-0.4, 0.41-1.25, 1.26-2.10 etc. (9 ranges in all, ending @13.60). Now
what I will be doing is entering a single number in a cell that will fall
into one of these ranges, and I want our grade number to automatically
pop up in the cell next to it, ..

One way is to try VLOOKUP

In Sheet2, set up a lookup reference table in cols A & B,
e.g.:

0.00 5.0
0.41 4.5
1.26 4.0
etc

Then in say, Sheet1, if you have the values in col A, in A1 down

Put in B1: =IF(A1="","",VLOOKUP(A1,Sheet2!A:B,2))
and copy down

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--