Hi,

Have your matrix of salary values and Grade level built like this:

Lowest value in salary range Grade level

23,000 C
25,000 B
29,000 A

Then, use this formula in column B

=VLOOKUP(A1,RANGE,2,TRUE)

where Range refers to the range where you have your salary & grade matrix.

Regards

Govind.


Tami wrote:
I need a formula to return a value in a column (say column B) for a number in
Column A based on a range: EX: As in grading, A = 90-100, B=80-90, etc.
I have a column of data of various salaries. If the salary is between x and
x, i need to return a corresponding letter set up by our salary grades.


example: here are the values
Grade Level A 29,000 - 30,000
Grade Level B 25,000 - 28,999
Grade Level C 23,000 - 24,9000

Column A Column B
Salary Grade Level
$29,500.00 A
$26,500.00 B
$25,100.00 B
$24,000.00 C

I want a formula in column B, that returns the corresponding value from
column A in column B. I tried IF statements using and = but I cannot get
it to recognize the range. thanks!