How do I find a column entry closest to a particular value
 

I'm trying to find the closest value in a column to a specified number, then
list it. Basically, I have a function in which I have to find 25% of the max
value and find which value in the data column that is closest. I was trying
to use a function to search the column but it wasn't working. any thoughts?

Thanks,
Dave

Try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

=INDEX(A1:A10,MATCH(MIN(ABS(A1:A10-B1)),ABS(A1:A10-B1),0))

....where B1 contains the specified number.

Hope this help!

In article ,
"feman007" wrote:

I'm trying to find the closest value in a column to a specified number, then
list it. Basically, I have a function in which I have to find 25% of the max
value and find which value in the data column that is closest. I was trying
to use a function to search the column but it wasn't working. any thoughts?

Thanks,
Dave