Hi Jeff

you can use the Lookup function if the numbers in B are sorted ascending
=LOOKUP(A1,B1:B100)

Cheers
JulieD

"Jeff" wrote in message
...
Hi

I have a list of numbers in column "B" and I also have a number in cell
A1.

I want to get the closest number in column B to the value in A1 using a
formula,
is this possible?

Thanks for your help.