I have 3 columns from sheet 1 I need to copy over to sheet 2. Date Absence Starts, Date Absence Ends, and Employee Name - Reason Code.
I have tried Index/Match and Vlookup, but I cannot figure out what I am missing to get my formula to work. After looking at some of the help discussions, I added a Row ID column to both sheets.
Both screen shots are of sheet 2, referencing the Row ID column and Date Absence Starts column of sheet 1.
