[Libreoffice-bugs] [Bug 153312] EDITING Data Validation/Vlookup pulldown list won't work unless items alphabetical
https://bugs.documentfoundation.org/show_bug.cgi?id=153312 --- Comment #4 from Paul Kinzelman --- Sorry, thanks for the clear explanation -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153312] EDITING Data Validation/Vlookup pulldown list won't work unless items alphabetical
https://bugs.documentfoundation.org/show_bug.cgi?id=153312 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153312] EDITING Data Validation/Vlookup pulldown list won't work unless items alphabetical
https://bugs.documentfoundation.org/show_bug.cgi?id=153312 Eike Rathke changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Eike Rathke --- 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.
[Libreoffice-bugs] [Bug 153312] EDITING Data Validation/Vlookup pulldown list won't work unless items alphabetical
https://bugs.documentfoundation.org/show_bug.cgi?id=153312 --- Comment #2 from Paul Kinzelman --- I forgot to mention, when I set up the Data | Validity box, I selected: "Cell range", then Allow empty cells (I did some testing with these as well) Show selection list And I had OFF this one: Sort entries ascending -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153312] EDITING Data Validation/Vlookup pulldown list won't work unless items alphabetical
https://bugs.documentfoundation.org/show_bug.cgi?id=153312 Paul Kinzelman changed: What|Removed |Added CC||p...@kinzelman.com --- Comment #1 from Paul Kinzelman --- Created attachment 185052 --> https://bugs.documentfoundation.org/attachment.cgi?id=185052=edit Simple example file that illustrates the bug -- You are receiving this mail because: You are the assignee for the bug.