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.
Bookmarks