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