Is your list of numbers sorted? In what order, ascending or descending? You
want the closest whether it's over or under?

Biff

"ADK" wrote in message
...
I have a sheet with specific numbers. On another sheet, the user would
input a value. I like excel to find that number or the closest number then
return the value in row/column X.

Example:

User inputs 124.5
The closest value in lookup is 124.25
then formula in the next cell returns the value in row/column X

Any way of doing this?