https://bugs.documentfoundation.org/show_bug.cgi?id=157896
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from Eike Rathke <[email protected]> --- Not a bug. VLOOKUP() is defined to lookup _matching_ values. A numeric value does not match a text value. Also note that a leading ' apostrophe you might see in the Input Line or while editing a cell is not part of the cell content and does not influence a lookup. It indicates that the input could be interpreted as a number if it was entered without the apostrophe in a cell formatted as numeric, and with apostrophe will be entered as text content. Editing such content means it was already entered as text. See also https://help.libreoffice.org/7.6/en-GB/text/scalc/guide/text_numbers.html?&DbPAR=CALC and https://help.libreoffice.org/7.6/en-GB/text/scalc/guide/integer_leading_zero.html?&DbPAR=CALC Your sample document does not contain such scenario though, because the cell range A1:A8 is formatted as Text, not numeric. -- You are receiving this mail because: You are the assignee for the bug.
