The issue may be that the data and the lookupValues tab numbers are not
exactly the same. -10.90001 and -10.9004 may display the same, but will not
match exactly. Your data in A1:A402 also has to be in ascending order for
Lookup to work properly

A sort may fix the issue, forcing an exact match should also help

=VLOOKUP(C4,LookUpValues!$A$1:$B$402,2,false) will force an exact match and
the data in A1:A402 and be in any order.

If this errors out your source (C4) and lookup data do not match exactly.
--
If this helps, please remember to click yes.


"awalker" wrote:

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.