Hi,
Any help you can provide on this would be appreciated. I have a worksheet
that identifies how far a number is from target. I created the lookup below
to coorespond to the productivity increase for next year.

=LOOKUP(C4,LookUpValues!$A$1:$A$402,LookUpValues!$ B$1:$B$402)

C4 is -10.9, in the lookupValues tab -10.9 is in row 93 column A as is the
desired result return of 5.6 in column b, however the lookup function is
returning 5.7.