Lookup value off by one row
 

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.

Lookup value off by one row
 

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.

Lookup value off by one row
 

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

"Paul C" wrote:

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.