Hi Sir,

I have a question about how to find a value which is the closest to a give value. For example,

if the given value is 0.1, and the list of available values are: 0.0, 0.3, 0.5, then the closest value is 0.0 (NOT 0.3).

In another case,

if the given value is 2, and the list of available values are 0, 3, 4, then the closest value is 3.

Not sure which look up function to use.

Thanks in advance