https://bugs.documentfoundation.org/show_bug.cgi?id=106342
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |miguelangelrv@libreoffice.o
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
There two issues with your file,
The data on the searched vector must be sorted.
LOOKUP() use regular experssions, so you must deactivated it because the comma
is part of the regular expressions.
To avoid the issue with regular expressions:
Menu/Tools/Options/LibreOffice Calc/Calculate - No wildcards or regex in
formulas
To avoid the sort issue you can use the MATCH() function in combination with
INDEX():
B2: =INDEX($Productos.$A$2:$A$5000;MATCH(B2;$Productos.$B$2:$B$5000;0))
https://help.libreoffice.org/Calc/Spreadsheet_Functions#LOOKUP
https://help.libreoffice.org/Calc/Spreadsheet_Functions#MATCH
There is no bug, please if you are not agree, reopen it.
--
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
