2015 Archives by date, by thread · List index

# 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
```