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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 16 06:38:59 UTC 2019


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

--- Comment #7 from gmolleda at us.es ---
The best solution:
VLOOKUP -> =INDEX (matrix_results ; MATCH( SearchCriterion ; LookupArray ;
type) ; column)
BUSCARH -> =INDEX (matrix_results ; row ; MATCH( SearchCriterion ; LookupArray
; type))
In Spanish:
BUSCARV  =INDICE (matriz_rtdos ; COINCIDIR( criterio ; vector_buscar ; tipo) ;
columna)
BUSCARH  =INDICE (matriz_rtdos ; fila ; COINCIDIR( criterio ; vector_buscar ;
tipo))

-- 
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/20191116/7a88f491/attachment.html>


More information about the Libreoffice-bugs mailing list