Good morning Brian and all:
I did this in my workbook:
Sheet 1 Sheet2
1st Matrix 2nd Matrix VlookUp
0 A.D. 0 A.D. Empires Ascendant =BUSCARV(A2;Hoja1.A3:A6;1;1)
2HFU 3D Chess
3D chess Abe
=BUSCARV(A4;Hoja1.A3:A6;1;1) 3D chess
In the first case I tried to find "0 A.D. Empires Ascendant" from 2nd
Matrix - sheet 2- in the 1st Matrix -sheet 1- and found "0 A.D." ... it
was good !
But in the second case I tried to find "3D Chess" that is the third
element in the first Matrix-Sheet 1- and the found result is "2HFU" ...
it isn't good and confused me.
In the last case I tried to find "Abe" and found "3D chess" more confuse
As I can see the VlookUp find always the element that continue in order
in the list of the 1st Matrix not the name that I'm finding.
And if I used "=BUSCARV(An;Hoja1.A3:A6;1;0)" with zero at end, the tree
results are "#N/D" ("An" is for not to repeat tree times the formula)
I don't know if I'm doing something wrong or there is a bug
Some time ago, VlookUp was using only to search exactly element (Only
equal) now it has so strange behaivor (At least to me)
El mié, 18-11-2015 a las 12:09 +0000, Brian Barker escribió:
At 06:01 18/11/2015 -0600, Jorge Rodríguez wrote:
Thank you for your support, ...
I just order both matrix alphabetically and I
tried to use VlookUp but it gave me a several false-positive as you told me.
If you get false matches from a simple VLOOKUP(),
it is possible that you have not set the fourth
parameter correctly. If, as here, there may not
be a match, you need to set the SortOrder
parameter to FALSE or zero, irrespective of whether the list is sorted.
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy