A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
For example in C2 on Sheet1:
=COUNTIFS(Sheet2!A:A, A2, Sheet2!B:B, B2)>0
Fill down.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 |
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
For example in C2 on Sheet1:
=COUNTIFS(Sheet2!A:A, A2, Sheet2!B:B, B2)>0
Fill down.
This worked! Thanks so much!