Previous Topic Next Topic

Comparing mailing addresses

Closed
jmanel - Oct 5, 2010 at 06:16 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 7, 2010 at 10:28 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 7, 2010 at 10:28 AM
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
0

Similar discussions

Multiple (4) IP addresses
Karakatari -
dwebb -

1 response
comparing two excel files
tt -
kumarapush123 -

2 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Comparing two columns using partial match logic
patallen8845 -
patallen8845 -

2 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses