Custom Function
You could just use an array formula:
=(SUM((J9=G$10:G$13)*(J9<=H$10:H$13))0)
.....where J9 is the value you are testing and G10:G13 are the lower
table values and H10:H13 are the upper table values.
Martin wrote:
I am in the process of trying to create a Function that will take a value and
determine if it appears in a table of ranges. For example, my table of
ranges may be:
Lower Upper
10000 15000
30000 35000
A C
g i
If I use a value of 11000, my function would return a 1 since it is in one
of the ranges. A value of d would return a 0.
|