You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/06/11 23:23:01 UTC

[Issue 126362] Vlookup may return incorrect values from list if there are similar list items

https://bz.apache.org/ooo/show_bug.cgi?id=126362

--- Comment #1 from wrigh <wr...@hotmail.com> ---
Comment on attachment 84789
  --> https://bz.apache.org/ooo/attachment.cgi?id=84789
Demonstration of errors in VLOOKUP

Additional to the attachment|:

A simpler version of the showing the errors
In cell J4 enter  "=VLOOKUP(G4;CTab;1;0)"   or "=VLOOKUP(G4;CTab;1;1)"
Copy down wards.
As Col G is the 1st column of CTab array, this should copy that column to J4.
It doesn't.

-- 
You are receiving this mail because:
You are the assignee for the issue.