In Workbook 1 I have a mailing list with typical fields, name, address, city,
st, zip, etc. This workbook has over 50,000 records and I need to pare down
the list based on zip codes.

In Workbook 2 I have 600 zip codes in column A and a unique value for each
zip code in col B, ranked 1 through 600.

Can I somehow add these zip code 'values' from workbook 2 into a new column
Workbook 1 if the zip code in Workbook 1 matches a zip code in Workbook 2?

Thanks.