I have 2 excel files that need to be combined. #1file provides general information along with name, street, city and state address. #2 file provides different general information and the city. I need to match the information and combine into one spreadsheet so that the #1 file has the #2 information for each entry/row.
Provide the results in a spreadsheet, excel 2003.