I have 2 excel spreadsheets that have the same patient names. In the spreadsheet called “ClarityScheduling_CTRC_Fo
rmatted” Column H which is the “StudyID” field is blank and I want to update that column from column C “Study ID” field of the other spreadsheet called “Clarity-CTRC Combination “ by matching the patient name and the date of Appointment together and then copying and pasting the corresponding “Study ID” from column C of the “Clarity-CTRC Combination.xls “ to column H of “ClarityScheduling_CTRC_Fo
s” I have done a couple of examples high light for you to see what I am trying to accomplish with 1173 records. The question is how can I accomplish copy and pasting the correct study IDs to the other spreadsheet. Attached are the 2 excel spreadsheets. Thanks in advance.