How to return a single value for a range of numbers
One way
=VLOOKUP(A2,{0,"C";24999,"B";29000,"A"},2)
where A2 is the first salary (29500)
you can create a table that in your example should look like
0 C
24999 B
29000 A
you can refer to that table as well
=VLOOKUP(A2,$E$2:$F$4,2)
copy down both formulas will return your desired result
--
Regards,
Peo Sjoblom
Portland, Oregon
"Tami" wrote in message
...
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!
|