I have a table D28:D1628 with values incrementing up to 5 decimal values.

In a different cell I generate a number that is not always identical to the values in the D28:D1628 column, therefore I need to approximate this value to the nearest one of the column.

Does anyone have an idea how to do this ?

Many many thanks in advance