Mapping incomplete list to a complete list

Hey everyone,

So in one worksheet, I've got one master list of every zip code in the US. I also have other worksheets with the amount of various "attributes" (restaurants, stadiums, etc) in every zip code in the US, 1 worksheet per attribute. What I want to do is take the amount of each attribute contained in a zip code, and paste it next to that zip code in the master list.

The issue is that each attribute list only has zip codes that have any of that attribute (so only zip codes with stadiums are listed in the stadium worksheet), so I can't just copy and paste the scores into the master list b/c I'd skip the zip codes that have 0 of that attributes.

There are about 40k zip codes, so doing it manually would be ridiculously cumbersome. Any ideas how to map each incomplete zip code list to the overall master list? Thanks.

May be I do not understand your final objective ...

But can't you, from the master list

one master list of every zip code in the US

add a vlookup() function to "bring back" whatever info you need ?

HTH
Carim