https://bugs.documentfoundation.org/show_bug.cgi?id=123746
Bug ID: 123746
Summary: Allow VLOOKUP function to work on the left specifying
a negative index
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: blackh...@lobianco.org
Description:
The VLOOKUP() function works specifying a value to look-up in a column X and
the number of columns on the right where to retrieve the desired output on the
same raw of the founded value.
Often however I find myself to have the value to look-up on the right, and the
return value on the left.
My suggestion is to allow specifying a negative index of number of column and
this would have to be interpreted to lookup the value on the rightmost column
of the interval given and return the value on the specified column on the left.
Steps to Reproduce:
VLOOKUP(A1:D10,"car",2,0) (current implementation) returns the value in the B
column at the row where on column A the word "car" is found.
VLOOKUP(A1:D10,"car",-2,0) (proposed implementation) should return the value in
the C column at the row where on column D the word "car" is found.
Actual Results:
Negative index results in an error
Expected Results:
Negative index should mirror the request and look at the left of the rightmost
column.
Reproducible: Always
User Profile Reset: No
Additional Info:
I never use it, but the same thing could possibly apply also to HLOOKUP()
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
