https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #5 from kyle sager <[email protected]> --- Sorry I left this go so long. Widowed dad juggling things! I just successfully duplicated this bug(?). I just realized this if probably not a bug if vlookup is intended to return the first line *before* a value if there is not an exact match. Here is an example table: A B C 1 A100002 100002 A100002 2 A100003 100003 A100003 3 A100004 100004 A100004 4 A100005 100005 A100005 5 A100006 100006 A100006 The problem I percieved was if there were spaces after data in the first column then the following happened The formula =VLOOKUP("A100003",A1:C5,3) returns A100002 But the formula =VLOOKUP("A100003 ",A1:C5,3) with space after A100003 returns A100003 I actually think this is intentional because lookup key, when it has a trailing space, is not an exact match. I will leave this "notabug." and apologized for the confusion. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
