On Sat, 02 Jun 2012 23:01:46 -0400, Ron Rosenfeld wrote:

On Sat, 2 Jun 2012 21:28:16 +0000, Abid Raza wrote:

If Cell E12 is between 33 & 41 E15 should return 4
If Cell E12 is between 34 & 42 E15 should return 3

O.K., Can we defined ranges as:
1. below 33 0 Point
2. 33-34 3 Point
3. 34-41 4 Point
4. 41-42 3 Point
5. Above 42 0 Point

Hope this makes easy to solve...........

It does not make it easy. Your problem is not possible to solve as stated because you continue to define overlapping ranges.

By that I mean your table shows two different outcomes given the same value in E12.

Your Line 2. shows that 34 -- 3 point
but your Line 3. shows 34 -- 4 point

Also

Your Line 3. shows that 41 -- 4 point
but your Line 4. shows 41 -- 3 point.

If your break points are really as follows:

<33 0

33 to <35 3
35 to <41 4
41 to 42 3
42 0

then you could try:

=VLOOKUP(E12,{-1E+307,0;33,3;35,4;41,3;42.0000000000001,0},2)