Match 2 different zip code lists

W

Will123

I have a large 42,000 list of US zip codes which each row (42,000 rows) has a
zip code column, a counties column and states column that I want to match to
a smaller 4,000 zip code list- with a zip code column & dollar amount column.
Or even, use all the Illinois zip codes matched to a smaller IL zip codes
list- so I can match same zip codes and corresponding county? Now, they are
set up on separate workbooks or worksheets. thanks.
 
W

Will123

great, this helps... also, what if I want to add one more column of city
names to go with counties... my long list has column C of city names...how
would I change the formula and add county and city to my short list.. thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top