Re: [libreoffice-users] Match Items from two different matrix

2015-11-20 Thread jorge
Hi Brian and all: I'm really sorry by my fail using LO spreadsheet and follow yours advises. Besides I didn't know the options of tools (LO-Calc-Calculate) Thank you again, Regards, Jorge Rodríguez El vie, 20-11-2015 a las 07:05 +, Brian Barker escribió: > At 09:44 19/11/2

Re: [libreoffice-users] Match Items from two different matrix

2015-11-19 Thread Brian Barker
At 09:44 19/11/2015 -0600, Jorge Rodríguez wrote: I did this in my workbook: Sheet 1Sheet2 1st Matrix 2nd Matrix VlookUp Result NameName Formula 0 A.D.

Re: [libreoffice-users] Match Items from two different matrix

2015-11-19 Thread jorge
I'm sorry if it was formated confuselly. I hope this is better: > > > > > > El jue, 19-11-2015 a las 09:44 -0600, jorge escribió: > > > Good morning Brian and all: > > > > > > I did this in my workbook: > > > > > > Sheet 1 Sheet2 > > > 1st Matrix 2nd Matrix VlookUp

Re: [libreoffice-users] Match Items from two different matrix

2015-11-19 Thread jorge
Good morning Brian and all: I did this in my workbook: Sheet 1Sheet2 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. 2HFU3D Ch

Re: [libreoffice-users] Match Items from two different matrix

2015-11-18 Thread Brian Barker
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 h

Re: [libreoffice-users] Match Items from two different matrix

2015-11-18 Thread jorge
Hi Brian: 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 toll me. But at this moment is my only way if not I would had to have it complete manual. Regards, Jorge Rodríguez El mié, 18-11-2015 a

Re: [libreoffice-users] Match Items from two different matrix

2015-11-18 Thread Brian Barker
At 08:52 16/11/2015 -0600, Jorge Rodríguez wrote: I understand now what you are saying I don't think you do - at least, not entirely. You haven't clarified the answers to various questions. I don't need the answers to these - but you do! - I need to find which games of the first Matrix app

Re: [libreoffice-users] Match Items from two different matrix

2015-11-16 Thread jorge
Hi Brian: I understand now what you are saying Following my last e-mail: - In the first Matrix (Sheet 1), I have a list of games from a site of internet (Column A) - In the second Matrix (Sheet 2), I have my own list of games. - Neither name is repeated into first Matrix or int

Re: [libreoffice-users] Match Items from two different matrix

2015-11-16 Thread Brian Barker
At 09:01 15/11/2015 -0600, Jorge Rodríguez wrote: I try to do better: Oh, I didn't mean to criticise, just to explain that any problem needs to be defined before it can be solved. a) Both matrix have column A (The first Matrix is in Sheet 1 and the second Matrix is in Sheet 2) b) I want to

Re: [libreoffice-users] Match Items from two different matrix

2015-11-15 Thread jorge
Thank you Brian: I try to do better: a) Both matrix have column A (The first Matrix is in Sheet 1 and the second Matrix is in Sheet 2) b) I want to compare the content of A1 of the first Matrix with all the column A of the Matrix 2 searching an equal or similar content string there. The

Re: [libreoffice-users] Match Items from two different matrix

2015-11-14 Thread Brian Barker
At 12:10 14/11/2015 -0600, Jorge Rodríguez wrote: I have two different matrix. One of them has a list of item from a site of internet. The other I made it. But both matrix are different but each row sometime has a equal word between them ... that word is what I'm finding to match both row. I

[libreoffice-users] Match Items from two different matrix

2015-11-14 Thread jorge
Hi all: I need your help I have two different matrix. One of them has a list of item from a site of internet. The other I made it. But both matrix are different but each row sometime has a equal word between them ... that word is what I'm finding to match both row.