Lookup value off by one row

[awalker]

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.

 

[Paul C]

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.

 

[awalker]

Paul,
Thanks for your help. I tried the formula and it errored out. I then tried
reformating both C4 and the lookup table but still no go...