[Libreoffice-bugs] [Bug 123746] Allow VLOOKUP function to work on the left specifying a negative index

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123746

--- Comment #2 from gmolleda at us.es ---
Related bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=124728
In other spreadsheet you can modify the matrix with the functions CHOICE:
        A       B
1       a       1
2       b       2
3       c       3
4       d       4

You can use for search: =VLOOKUP(2;CHOICE({2\1};a1:a4;b1:b4);2;FALSE) and you
obtain the result "b".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190414/c5fdc8f0/attachment-0001.html>