[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 #3 from gmolleda at us.es ---
The solution is:
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/20190415/9a007247/attachment.html>