Hi all,
I was wondering if it was possible to merge two separate spreadsheets, based on specific information.
I have two spreadsheets, one has information regarding transactions, with about 15 different columns. The other has information regarding indexes with about 60 different columns.
Both spreadsheets however, contain two columns which provide, 1) a specific date (monthly), and 2) a specific postcode. (The rest of the columns for the two spreadsheets contain completely different information ).
What I want to do is to merge rows from the two sheets, which contain BOTH the same postcode and same specific monthly date. I want also to retain all the information from both spreadsheets' columns when I merge the tables together. (So each row should have 70+ collumns of information).
I know v-look up tables may offer a solution. However, is this still possible when the merging depends on matching two columns of information and when i'm looking to merge all potential information fro both tables? Additionally, to make things more complicated, the spreadsheet containing information regarding indexes will contain some combinations of postcodes and dates which don't exist in the spreadsheet containing transactions.
Is there a way of doing this?
Many Thanks
Bookmarks