You can accomplish this using VLOOKUP in excel.

Option 1: If you want to copy your separate excel files into one workbook, you can use VLOOKUP to copy data from one sheet in the workbook to another (i.e. from the notes sheet, copy the note body & timestamp into the contact sheet) Here is a handy guide: https://blog.import2.com/join-multiple-data-sheets-in-excel-using-vlookup-function/ 2)

Option 2: If you still have your sheets in separate workbooks (excel files), you can also use VLOOKUP to copy data from one sheet to another (here is a video on how to ensure it works properly:

Did this answer your question?