Comparing 2 colums in 2 sheets

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.

Try this
C1 =SUMPRODUCT(--(thatone!J1:J40000=A1),--(thatone!K1:K40000=B1))

Copied down.

HTH,
windknife