find the closest value between numbers in different datasets

Hi everyone,

I would like to find for each value of "Ref mass" the closest value (smallest differece) in "New mass" and report it in "closest value".

Do you know how to do it???

Cheers,

Simone



Ref mass New mass closest value
9000.009180 8999.851720 9000.006263
9000.031260 8999.873797
9000.053340 8999.895875
9000.075420 8999.917952
9000.097500 8999.940030
9000.119570 8999.962107
9000.141650 8999.984185
9000.163730 9000.006263
9000.185810 9000.028341
9000.207890 9000.050419
9000.229970 9000.072498

If you mean closest without going over
then this should work

=INDEX(B$1:B$11,MATCH(A1,B$1:B$11,1),1)

and copy down C column