|Your address ZIP goes in column - A|
Wealthy ZIP goes in column - C
1. Type the following formula in cell B1:
=IF(ISERROR(MATCH(A1,$C$1:$C$150,0)),"","Match in Col C")
2. Select cells B1:B350
3. Then "Edit", select "Fill" on the Edit menu, and then click “Down”.
This will compare Column A against Column C and insert the comment "Match in Col C" next to the name in Column A matched in Column C.
The columns do not have to be sorted, although it might be easier.
I Started at Row 1, change the formula if needed.
I used only 350 rows to check, again change if needed.
If you want the number 1 for a match, change the text.