Equation: equals number if another number is between a certain range

[njsutorius]

I would like to have a grade scale so that where c3 = wherever b3 falls in the range in column A.

Thus if B3 is 10 then C3 would equal 4.5 on the scale range.

We can breakout the range in A if needed into multiple columns if necessary.

	a	b	c
1	1-5 = 0	CPH	Score
3	6-8 = 3.5	10
4	9-11 = 4.5
5	12+ = 5
6
7

<tbody>
</tbody>

Thanks for any assistance.

 

[shg]

	A​	B​	C​	D​	E​
1​	CPH​	Score​	CPH​	Score​	​
2​	0​	0.0​	10​	4.5​	D2: =LOOKUP(C2, $A$2:$B$5)
3​	6​	3.5​
4​	9​	4.5​
5​	12​	5.0​

 

[njsutorius]

You win the prize of my thankfulness. You are a great resource to helping your fellow man. Thanks!

 

[shg]

Wow, you're welcome.

 

[mfexcel]

vlookup would also be a common solution for your problem.

Hope this helps you understand better
vlookup – True or False?? | wmfexcel

 

[njsutorius]

Ya that vlookup is pretty much right up my ally on this question. I am going to read your article in detail as I think vlookup may be useful for some of my other ideas as well.