Determining A Rating

[Edwin Villamayor]

Hello,

Suppose I have the following table:

A B C
1 3 <3.80
2 3- 3.80 3.99
3 4+ 4.00 4.19
4 4 4.20 4.79
5 4- 4.80 4.99
6 5+ 5.00 5.19
7 5 5.20 5.79
8 5- 5.80 5.99
9 6+ 6.00 6.19
10 6 6.20 6.79
11 6- 6.80 6.99
12 7 7.50 7.99
13 8 8.50 8.99
14
15 4.91
16 4-

Where A is a rating/score
B is the low value range
C is the high value range

If I have a value in A15 of 4.91 (which is in the range of 4.80 and
4.99), I would like to return a rating in A16 of 4-. I've tried using
a series of IF statements, but there seems to be a string limitation.
I've also tried using the VLOOKUP function, but I can't seem to get a
correct answer. Can anyone suggest an alternative to my predicament.

Thanks in advance.

Edwin

 

[J.E. McGimpsey]

one way:

Change B1 to 0, then use

=INDEX(A:A,MATCH(A15,B:B,1))