vlookup and going to the next largest value

Hi Nick,

Back in March 08 you posted a query regarding using vlookup and going to the next largest value (rather than the default nearest lesser value).
Sweep/Dave replied with an answer for you which appears to have solved your problem.

Only the link to the solution doesnt seem to work anymore!
http://www.excelforum.com/showthread.php?t=636366

Any Chance you can remember this solution and forward it to me please?!

Many Thanks in Advance
Rich

If your range of numbers is in A1:A10 and the lookup value is in C3 this formula will give you the smallest value in A1:A10 that is greater than or equal to C3

=MIN(IF(A1:A10>=C3,A1:A10))

confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

If C3 is greater than all values in A1:A10 then the formula returns 0