Is there a formula to find Matching data-sets between two sheets?

Anonymous
2025-01-28T14:25:35+00:00

I have two sheets with correlative data.

What I need to know is, are there any rows in Sheet2 where Column A and Column B match the corresponding columns of any row in Sheet1?

In other words, I want to search all of Columns A & B of Sheet2 for any matches to Row1 of Sheet1, if there is a match I’d like it to return “True”, if not I’d like it to return “False”.

I’ve provided an example of what Sheet1 and Sheet 2 look like below. For context these sheets are roughly 3-4 thousand rows each in reality.

You’ll notice that in the example, Row 2 of Sheet 1 has matching data with Row 3 of Sheet 2.

That is where I’d like a return value of True, whereas the other rows should return a value of False since there is no other data that matches BOTH columns between each sheet.

(Sheet1)

Part Number <br><br>(Column A) Locator<br><br>(Column B)
MS62187-12 1669-EFP-B2-0-26KDL
8027A24-003 1545-6S-B8-0-22DLG
8027A24-003 1545-99-B1-0-26KDL

(Sheet2)

Part Number<br><br>(Column A) Locator<br><br>(Column B)
AA623-B-5005 1669-EFP-B3-0-22DLG
MS21235-4 1669-4F-FAB-0-
8027A24-003 1545-6S-B8-0-22DLG
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2025-01-28T15:10:38+00:00

For example in C2 on Sheet1:

=COUNTIFS(Sheet2!A:A, A2, Sheet2!B:B, B2)>0

Fill down.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2025-01-28T15:48:50+00:00

    This worked! Thanks so much!

    Was this answer helpful?

    0 comments No comments