Use VLOOKUP.
For example, if your list in Column B is in B1:B5:
=VLOOKUP(A1,$B$1:$B$5,1,1)
tj
"Jeff" wrote:
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.
|