Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge data from two separate tables | Excel Worksheet Functions | |||
Merge data from two separate tables | Excel Discussion (Misc queries) | |||
hOW TO MATCH DATA CONTAINED IN DIFFERENT TABLES | Excel Discussion (Misc queries) | |||
Look-up (match) and merge data | Excel Worksheet Functions | |||
How do I match and append/merge data from two spreadsheets? | Excel Discussion (Misc queries) |