https://bugs.documentfoundation.org/show_bug.cgi?id=153312
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Eike Rathke <[email protected]> --- VLOOKUP() without 4th parameter or 4th parameter's argument being not 0 does a range lookup for which the lookup range MUST be sorted ascending. If you want an exact match instead specify 0 as 4th argument, like =IFERROR(VLOOKUP(D4;A5:B8;2;0);" ") See online help https://help.libreoffice.org/7.5/en-GB/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 Btw, I'd not use IFERROR() but IFNA() instead to not suppress other than #N/A errors. Not a bug. -- You are receiving this mail because: You are the assignee for the bug.
