Is there a formula similar to vlookup except it matches a value with a RANGE?

Hello,

I am somewhat of an advanced user of Excel (which is why it kind of pains me to have to ask for help on this), but I cannot seem find a formula that satisfies the goal I'm trying to achieve.
I'm looking for a formula that performs similar to a vlookup... in the respect that it references a column/cell, matches against a certain criteria, and then returns another value based on that criteria.
Where a vlookup takes one value, matches with another value, and then returns a value... I would like it to take one value, match within a range of two values (505 is between 500-509, therefore return "blank" value).

See the attached list for an example of how this would be used.

I appreciate the help!

Chris

You can use this formula in C2:

=VLOOKUP(B2,$E$2:$G$28,3)

then copy down.

Hope this helps.

Pete