Extracting data from one sheet into another
 

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.

Extracting data from one sheet into another
 

Consider moving the 600 entry table from the second workbook to a new tab in
the first workbook. This will avoid having workbook-to-workbook links.

See =VLOOKUP() in Excel help. This will enable you to retrieve values for
each ZIP code in the large table.
--
Gary''s Student - gsnu200768


"T" wrote:

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.

Extracting data from one sheet into another
 

Sounds easy enough, thank, I'll try it now.

"Gary''s Student" wrote:

Consider moving the 600 entry table from the second workbook to a new tab in
the first workbook. This will avoid having workbook-to-workbook links.

See =VLOOKUP() in Excel help. This will enable you to retrieve values for
each ZIP code in the large table.
--
Gary''s Student - gsnu200768


"T" wrote:

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.