Comparing mailing addresses

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I am trying to track a direct mail campaign using customer addresses. I want to compare my database spreadsheet to the direct mail spreadsheet. I want to find matching addresses from one sheet to the other. Every match indicates a customer who came in as a result of the direct mail piece. Whether they are an existing customer is a task for another search.
Thanks for your help.
John

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi John,

On sheet1 I put the following example data:
aaa
bbb
ccc
ddd
eee
On sheet2 I put the following example data:
bbb
ddd
fff
ggg

Then I put the following formula in B1 of sheet1:
=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$A$4,1,FALSE)),"NOT FOUND","FOUND")
Drag the formula down to see which data is found and which are not.

Does this solve your query?

Best regards,
Trowa