Good morning Brian and all: I did this in my workbook:
Sheet 1 Sheet2 1st Matrix 2nd Matrix VlookUp Result Name Name Formula 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) Regards, 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 > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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