Match Items from two different matrix

users
#1

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.

  I used Vlookup but it doesn work for me. Do you know another way to
find that word to match the rows.

Regards,

Jorge Rodríguez

#2

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

#3

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

#4

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

Actually, most of that was clear previously. Since you are now comparing cells from different sheets, instead of
=A1=B1
you need something like
=Sheet1.A1=Sheet2.A1
- filled down a column, of course.

But as soon as you use a word such as "similar", that needs defining accurately before you can construct the formulae you need. LibreOffice will not read your mind. Are "My dog's name is Fido" and "My dog's name is Rover" similar? Are "My dog's name is Rover" and "I often buy rover tickets" similar? Are "My dog's name is Rover" and "Today is Monday" similar? (They both contain "is".) Are "16th November" and "November 16th" similar? Are "The cat sat on the mat" and "The cat sat on the mat." similar? How about "Jorge Rodríguez" and "Jorge Rodriguez"? Or "John Smith" and "John Smith"?

You also haven't clarified what sort of result you need: is a simple column indicating whether each row satisfies your similarity criterion (as produced above) what you need?

I trust this helps.

Brian Barker

#5

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 into second Matrix

- I need to find which games of the first Matrix appear in the second
Matrix finding equal string or equal word into the string. For example:

First Matrix: Second Matrix:

Column-Row A1 Column-Row A6

0 A.D. 0 A.D. Empires Ascendant

The content of A1 and the content of the A6 are about the same game but
they uses different name (One single and the other complete)

I need to find A1 for A6 in Column B6 of Second Matrix by the key in
this case "0 A.D." that appear in both names.

Sometimes, both, the name of the game of the First Matrix and the name
of the second Matrix are equals.

I try to do this by formula unknowing the exactly key but knowing that
there is.

Thank you again,

Regards,

Jorge Rodríguez