User enters ID # in cell I2 in workbook "Eval_Rprt_02-33" I need it to compare values in second workbook "Eval_log" if IDs match then return "Date performed" from column "F" and auto enter it into cell G2 in Eval_Rprt_02-33. Do both the workbooks have to be stored in the same folder and do they both have to open at the same time? Not an advanced user in macros or VB.