Hi everyone,

I am trying to search for whether a data is within a range (multiple
ranges).

example:

data value = 1

range 1 = 0 - 3
range 2 = 4 - 5
range 3 = 6 - 10

and so on

if data value is found within a range, the range number is return. in
this case, range 1 will be return


I am doing this for a large number of ranges, if there a way to it?

Thanks
Allen