https://bugs.freedesktop.org/show_bug.cgi?id=54497

--- Comment #1 from drevicko <[email protected]> ---
I think your code snippet was meant to be something like this:

a1:a4={"A","a","=char(192)","=char(224)"}
b1:b4={1,2,3,4}
=VLOOKUP(A1,$A$1:$B$4,2,0) is 1
=VLOOKUP(A2,$A$1:$B$4,2,0) is 1
=VLOOKUP(A3,$A$1:$B$4,2,0) is 3
=VLOOKUP(A4,$A$1:$B$4,2,0) is 4

Note that char(192) and char(224) ARE detected as different..

-- 
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

Reply via email to