Number conversion

[hatricke]

How do I get a number entered into a cell to return a value based on a range? example below

Range	Value
0-150	1
151-200	2
201-281	3			Number entry	Returned value
282-300	4			216	3

[#2 · Accepted solution]

@hatricke 

You could arrange your data like this:

Then use VLOOKUP with an approximate match:

=VLOOKUP(E5,A2:B5,2,1)