Merge & Match 2 Excel Data Tables

[zsange]

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!!

 

[Tom Ogilvy]

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

See Excel help for details on Vlookup.