Hi , What you want to do is always select the value close to the input value? If so, you can pretend to take the difference of the values in the datatable according to the input value and select the little difference.
Will there be a possibility of having an input in the below way ? :
In this case, we do have the input value, but the First value itself is greater than the input value , so do we stop and take the Input value or do we need to find the value (or sum of values that make the value) in the other consecutive cells ?
Let us know if the ordering is done first either Descending/Ascending or keep the received input as it is ?