Hello guys,
my name is Stephanie from London and I have a very short, but urgent question. It sounds stupid, but I caint come to a solution.
I have to analyse 2 Spreadsheets with massiva Data (about 35 Tausand lines each) to see if the colums match each other.
My question is there any way/ function/ vlookup or anything else of seeing if
Spreadshead "thisone": Column A and Column B matches with
Spreadsheet "thatone": Column J and Column K.
With the result: True or False
I would be very, very grateful for your help.
Stephanie.
Hi Stephanie from London,
if I understood well you want this:
=ISNA(MATCH(A1;Sheet2!$A$1:$A$31;0))
But be carfull, this will give you FALSE if there is name in other sheet, and TRUE if there isn't.
$A$1:$A$31 is range on other sheet, you can put anything you need.
"Relax. What is mind? No matter. What is matter? Never mind!"
MOTD: Until I taste a lion pig is a King of animals to me.
Try this
C1 =SUMPRODUCT(--(thatone!J1:J40000=A1),--(thatone!K1:K40000=B1))
Copied down.
HTH,
windknife
another possibility if you want to find if any two adjacent cells match anywhere in the other sheet
=ISNUMBER(MATCH(A1&B1,INDEX(Sheet2!$J$1:$J$16&Sheet2!$K$1:$K$16,0),0))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks