Merge & Match 2 Excel Data Tables
 

I have 2 Excel data tables with the following columns

Table 1
Street Address, City, State, Revenues

Table 2
Street Address, City, State, ZipCode

I want to create a new column in Table 1 that takes the appropriate zip
code from Table 2 using a lookup and match on the street address. How
can I do that??

Thanks!!

Merge & Match 2 Excel Data Tables
 

Use the vlookup worksheet function. You don't need a macro.

See Excel help for details on Vlookup.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
I have 2 Excel data tables with the following columns

Table 1
Street Address, City, State, Revenues

Table 2
Street Address, City, State, ZipCode

I want to create a new column in Table 1 that takes the appropriate zip
code from Table 2 using a lookup and match on the street address. How
can I do that??

Thanks!!