Lookup value off by one row

  • Thread starter Thread starter awalker
  • Start date Start date
A

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.
 
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.
 
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...
 
Back
Top