https://bugs.documentfoundation.org/show_bug.cgi?id=95395
Bug ID: 95395
Summary: EDITING: VLOOKUP fails whith 1st parameter is a named
range
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gerard.farg...@orange.fr
Created attachment 120046
--> https://bugs.documentfoundation.org/attachment.cgi?id=120046&action=edit
test file with VLOOKUP erroneus result
When using a named range as search criterion with VLOOKUP, the formula is
expected to use the criterion of the named range which is on the same relative
position (same row) as the formula.
Example : VLOOKUP(column1,table,2,0) entered in D2 search for item in "column1"
row 2.
With 5.0.2, VLOOKUP search always 1st item of "column1" whatever the position
of the formula.
Open the attached file with 5.x and with 4.x and you will see what I mean.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
