You might try the "closest match lookups" section on my Lookups page.
http://www.cpearson.com/excel/lookups.htm about 2/3 of the way down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


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