Excel Formula/Function

March 20, 2009 at 14:51:49
Specs: Windows XP
I have a data set with addresses, and I want to compare the zip codes in the address list to a list of known "wealthy" zip codes. So, I want to write a formula that will look at the zip code in the data set, then check if it is an exact match to any of 350+ zip codes in a separate list. If it is, it should return a "1," if it is not, it should return a "0." Is this possible using Excel 2007?

See More: Excel Formula/Function

Report •

March 21, 2009 at 07:48:20
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.


Report •

March 23, 2009 at 06:26:54
This worked beautifully. Thanks a bunch!


Report •

March 23, 2009 at 06:43:25
Glad I could help.


Report •

Related Solutions

Ask Question