VLOOKUP returning incorrect value

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

I am having a problem with VLOOKUP. It is returning the
wrong value about 10% of the time. The table array is
sorted. The Lookup_Value is a formula adding 7 cell
values. The formulas for the precedent cells are
VLOOKUPS (which are returning the correct value). I
checked to see if it is a rounding issue but it is not.
When I copy the cell that contains the Lookup_Value, and
PasteSpecial in the same cell then the formula returns
the correct value. Any ideas? I think that I have tried
everything. I used Index() and Match() and the same
wrong value was returned. Could this be a bug in excel?
If so, how do I notify Microsoft and can I send the file
for review?
 
I checked the format of all of the cells and they are all
formatted as numbers (0.00)
 
The formula you sent below worked like a charm.
I appreciate your help!
**********************************************
Sometimes xl does things in a funny way. Even though your
sum is 3.00 there
is a minute difference.

=VLOOKUP(ROUND($U2,2),$E$45:$H$60,4,TRUE)
Please report this back to the ng with the formula.

Don Guillett
SalesAid Software
(e-mail address removed)
 
Back
Top