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