Excel 2007 : Match two columns of data

[Omaha_Mel]

Hello, (first post!)

In Column A, I have zip codes of visitors to our local museum. In Column B, I have a list of every zip code in the country.

How do I find matches?

[mdbct]

To what end?
Do you want the location for the ZIPS in the A column?
Do you just want to see if particular ZIPs in the B column have had a visitor?

If the former (assuming city is in the C column)

Please Login or Register  to view this content.

If the latter,

Please Login or Register  to view this content.

[NBVC]

In column C

=Isnumber(Match(B1,A:A,0))

This will look for zipcode from B1 in column A and return TRUE if it exists (meaning zipcode has visitied).

[Omaha_Mel]

It was the latter & the formula worked. Thank you! I guess if I put some context around what I'm doing, it might make more sense.

I'm assisting on an economic impact study to see how many people & where they come from, visit our local children's museum. I have list of about 16K zip codes in Column A, some zips are listed multiple times because we had multiple visitors from that city.

In Column B, I have the zip code for every city in the country.

What I'm trying to figure out, is how many people are coming from each zip code in Column A.

[JBeaucaire]

In that case I would use a COUNTIF() formula.

=COUNTIF(rangeofvisitorzipcodes, onezipcodeinlist)

So in C2:
=COUNTIF(A:A, B2)

[mdbct]

How about this one then - it will give you a count by zip code

Please Login or Register  to view this content.