| 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) | |||
Hybrid Mode
