How to search in range of numbers

[Anonymous]

Hi all,

Question about search in a range of numbers.

Let's say I have the number 2.050. I would like to find the nearest number and then select the data in the second column.

Number	Data
1.000	A
1.550	B
1.800	C
1.900	D
2.000	E
2.075	F
3.000	G

Could one you explain to me how to do this?

Cheers,

Henco

[Anonymous]

Ah of course, thanks a lot for helping me out.

Cheers,

Henco

[Anonymous]

Still one question: the input number is a sum in my live app.

It is not possible to change the expression like this:

firstsortedvalue(Number, fabs(Number-sum(Number_input)))

Is there another way to do that?