Merging data from 3 spreadsheets into one for mail merge data set.

[stewart@itsit.com.au]

I have 3 separate spreadsheets that I'd like to merge data into one of them to be used as mail merge data set.

Once is called Session # - Results.xltm (with 2 Tabs, Mail Merge & Results.csv.) When the Session # - Results.xltm is opened it appends the data on the Tab Results.csv with data from results.csv.

I need to include a VLookup in Session # - Results.xltm in column R that looks up the value in Column I and returns the value that matches Column I from workbook Upgrades.xlsx Column M.

I can provide samples of the spreadsheets or if anyone has a better way of achieving the same results more efficiently I'd be open to seeing them.

Thanks.

[AliGW]

Excel 2016 on 365 Subscription

How is this possible? If you are on a 365 subscription, you should be using Excel 365. Please double-check this and update your forum profile accordingly.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.