Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Good morning Brian and all:

    I did this in my workbook:

Sheet 1            Sheet2
1st Matrix  2nd Matrix                                          VlookUp
Name           Name
0 A.D.           0 A.D. Empires Ascendant       =BUSCARV(A2;Hoja1.A3:A6;1;1)
0 A.D.
2HFU            3D Chess
=BUSCARV(A3;Hoja1.A3:A6;1;1)    2HFU 
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
to me.

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)


Jorge Rodríguez

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

No probs!

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.

Brian Barker


Jorge Rodríguez

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.