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

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 content in all rows of the column A of the Matrix first is
different between them. In second Matrix too.

c) I need continue to do this with A2...An of the first Matrix with all
the column A of the Matrix 2

        I hope do better at this time

Regards,

Jorge Rodríguez



El dom, 15-11-2015 a las 06:11 +0000, Brian Barker escribió:
> 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 fancy the problem needs to be better defined.
> o Is the equal word the entire contents of each 
> cell or are you looking for substrings in common?
> o What do you expect as the result? Just an 
> indication in each row of whether the cells are 
> identical? A separate list of row numbers that 
> satisfy the criterion? A separate list of words 
> that match? A separate list of unique words that match?
>
> Try =A1=B1 in C1 and fill down. Or =IF(A1=B1;"Snap!";"").
>
> > I used Vlookup but it doesn't work for me.
>
> You would use VLOOKUP() if you wanted to search 
> all the rows of one column for a match for each 
> cell in the other - which is not what you appear to want here.
>
> I trust this helps.
>
> Brian Barker

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscribe@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