One way:

Instead of

=VLOOKUP(A1,J:K,2,TRUE)

use

=INDEX(K:K,MATCH(A1,J:J,TRUE)+1)


In article ,
"Mark" wrote:

I am attempting to use vlookup with values that have many decimal places.
The problem is they are close enough for an exact match so I must use an
approximate. I always get a value that is one before the value I wish to
have because it takes a value lesser than the one I am trying to match. Is
there a way I can get it to take the value in the next row? The numbers are
in numerical order.

Thanks