I am trying to find a match of addresses in two tabs on same workbook. I have 174 addresses in one tab and 2000 in the other tab. I am trying to find if there are any matches between the two. How do I do this?

Question

I am trying to compare and match of addresses in two tabs on same workbook. I have 174 addresses in one tab and 2000 in the other tab. I am trying to find if there are any matches between the two. How do I do this?

So the example is Tab 1 - I have 2000 addresses if clients since 2000; in Tab 2 I have addresses of clients from 2024 - I want to find any and all that are the same between the two tabs.

I suspect I use Match function but I am not sure if so and if so how?

Answer 1

Hi @Anonymous

According to your description, I create a simple sample as following images.

I suggest you enter the formula in a worksheet that has less address data, and drag it down : =VLOOKUP(A2,Sheet1!$A$2:$A$10,1,FALSE), then we will know if the address exists on both worksheets

If not, the message "#N/A" will be displayed.

And then you can continue to enter the formula: =FILTER(A2:A7,NOT(ISNA(C2:C7))), this formula can find out the duplicate address that without "#N/A".

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---