Extracting data from one sheet into another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T - 08 Feb 2008 14:26 GMT

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.

Reply to this Message

Gary''s Student - 08 Feb 2008 15:22 GMT

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.

Signature

Gary''s Student - gsnu200768

> 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
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

T - 08 Feb 2008 18:24 GMT

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

> 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.
[quoted text clipped - 13 lines]
> >
> > Thanks.

Reply to this Message