Is there a function is excel where the nearest value can be looked up?
For an example consider the following.
Assume this information is in the range (A1:A3). if I use vlookup(1499,A1:A3,1) this returns 1000. Is there another function that would choose 1500 which is the closest match.
I would appreciate any comments on this.