https://bugs.freedesktop.org/show_bug.cgi?id=48358
Michel Rudelle <mchl.r...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
CC| |mchl.r...@gmail.com
--- Comment #5 from Michel Rudelle <mchl.r...@gmail.com> ---
(In reply to comment #3)
> VLOOKUP seems more suitable for me.
>
> HLOOKUP should be used in a horizontal matrix
>
I confirm that there is a wrong use of HLOOKUP and this is not a bug:
Complying with ODF standard:
Open Document Format for Office Applications (OpenDocument) Version 1.2
Part 2: Recalculated Formula (OpenFormula)Format
OASIS Standard 29 September 2011
HLOOKUP function is defined § 6.14.5 page 130:
"Summary: Look for a matching value in the first row of the given table, and
return the value of the indicated row."
VLOOKUP function is defined § 6.14.12 page 136:
"Summary: Look for a matching value in the first column of the given table, and
return the value of the indicated column."
In your example, you want to look in the first column, so you must use VLOOKUP.
Notice also that arguments of your function are incorrect (the 3rd argument
should be an integer). For obtaining what you want, you must use:
=VLOOKUP (B4;A7:B148;2)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
