Created attachment 116827 [details] The option screen See the .ods attached. I made a very simple list with 3 items. I make three simple research on it. 2 of them give false or unexpected result. Note: the "entire cell" option is disabled. PS: "recherche" stands for "lookup", in french. Here is my Debian version of LO: $ apt show libreoffice Package: libreoffice Version: 1:4.3.3-2 Installed-Size: 126 kB Maintainer: Debian LibreOffice Maintainers <debian-openoffice@lists.debian.org> Depends: fonts-sil-gentium-basic, libreoffice-base, libreoffice-calc, libreoffice-core (= 1:4.3.3-2), libreoffice-draw, libreoffice-impress, libreoffice-math, libreoffice-report-builder-bin, libreoffice-writer, libreoffice-avmedia-backend-gstreamer | libreoffice-avmedia-backend-vlc, fonts-dejavu, libreoffice-java-common (>= 1:4.3.3~), python3-uno (>= 4.0~) | python-uno Recommends: fonts-liberation | ttf-mscorefonts-installer, libpaper-utils Suggests: cups-bsd, hunspell-dictionary, hyphen-hyphenation-patterns, iceweasel | firefox | icedove | thunderbird | iceape-browser | mozilla-browser, imagemagick | graphicsmagick-imagemagick-compat, libgl1, libreoffice-gnome | libreoffice-kde, libreoffice-grammarcheck, libreoffice-help-4.3, libreoffice-l10n-4.3, libsane, libxrender1, myspell-dictionary, mythes-thesaurus, openclipart-libreoffice, pstoedit, unixodbc, gstreamer1.0-plugins-base, gstreamer1.0-plugins-good, gstreamer1.0-plugins-ugly, gstreamer1.0-plugins-bad, gstreamer1.0-ffmpeg, default-jre | gcj-jre | openjdk-7-jre | openjdk-6-jre | sun-java5-jre | sun-java6-jre | java5-runtime | jre, libreoffice-officebean Homepage: http://www.libreoffice.org Tag: role::metapackage Section: metapackages Priority: optional Download-Size: 69,7 kB APT-Manual-Installed: yes APT-Sources: http://ftp.be.debian.org/debian/ jessie/main amd64 Packages Description: office productivity suite (metapackage) LibreOffice is a full-featured office productivity suite that provides a near drop-in replacement for Microsoft(R) Office. . This metapackage installs all components of libreoffice: * libreoffice-writer: Word processor * libreoffice-calc: Spreadsheet * libreoffice-impress: Presentation * libreoffice-draw: Drawing * libreoffice-base: Database * libreoffice-math: Equation editor . You can extend the functionality of LibreOffice by installing these packages: * hunspell-*/myspell-*: Hunspell/Myspell dictionaries for use with LibreOffice * libreoffice-l10n-*: UI interface translation * libreoffice-help-*: User help * mythes-*: Thesauri for the use with LibreOffice * hyphen-*: Hyphenation patterns for LibreOffice * libreoffice-gtk: Gtk UI Plugin, GNOME File Picker support, QuickStarter for GNOMEs notification are * libreoffice-gnome: GIO, GConf backend * libreoffice-kde: KDE UI Plugin and KDE File Picker support * unixodbc: ODBC database support * cups-bsd: Allows LibreOffice to detect your CUPS printer queues automatically * libsane: Use your sane-supported scanner with LibreOffice * libxrender1: Speed up display by using Xrender library * libgl1: OpenGL support * openclipart-libreoffice: Open Clip Art Gallery with LibreOffice index files * iceweasel | firefox | icedove | thunderbird | iceape-browser | mozilla-browser: Mozilla profile with Certificates needed for XML Security... * openjdk-6-jre | gcj-jre | java5-runtime: Java Runtime Environment for use with LibreOffice * pstoedit / imagemagick: helper tools for EPS thumbnails * gstreamer0.10-plugins-*: GStreamer plugins for use with LibreOffices media backend * libpaper-utils: papersize detection support via paperconf * bluez: Bluetooth support for Impress (slideshow remote control
Created attachment 116828 [details] The rendered computation
Created attachment 116829 [details] The example case
Hi François Vlookup is not broken. Since you omitted the 4th VLOOKUP parameter (sort order) LibreOffice assumes that your list is sorted (in your case it is not). If you add the fourth parameter =0 (meaning list is NOT sorted) then all results will be 1 Alternatively you could sort the list alphabetically by the first column (which is what LibreOffice expects and then the result will be 1,1,2
Thanks. I misread the documentation. I find this behavior quite disappointing. But I agree it is not a bug. I can't change this bug's status for notabug or something similar.
(In reply to François Poulain from comment #4) > Thanks. I misread the documentation. > > I find this behavior quite disappointing. But I agree it is not a bug. > > I can't change this bug's status for notabug or something similar. No problem. I will change it. Please keep reporting any bugs you find. Thank you for contributing to LibreOffice!