https://bugs.documentfoundation.org/show_bug.cgi?id=160155
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|NEEDINFO |RESOLVED --- Comment #2 from Eike Rathke <[email protected]> --- You have regular expressions in formulas enabled, hence looking for value "[I5020]" searches a character of the set [I5020]. To search for the literal string either use "\[I5020\]" or force it to literal by surrounding it with \Q and \E, e.g. =VLOOKUP("\Q"&C32&"\E";$B$3:$F$22;3;0) See also https://help.libreoffice.org/7.6/en-GB/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 Not a bug. -- You are receiving this mail because: You are the assignee for the bug.
