use a helper column with interpolted values between your main value set.
look up on this column.

"lepche" wrote:

I'm trying to match the lookup value with the number closest (larger or
smaller) than the value. Can this be done?