See the "Closest Match Lookups" section at
http://www.cpearson.com/excel/lookups.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"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.