How to match a value >= target value??
Posted by Rajiv Bhushan on June 28, 2001 1:19 PM
I have the following problem,
I have a target value say 0.77, I need to find the 1st row in a lookup
array (that has to remain unsorted) where the value exceeds the target
The value returned in this example should be either 5 (the row number),
or 0.78 (the value). I cannot use MATCH(), because it requires the column
to be sorted to produce the right answer. How can I do this???