Copy column from 1 sheet to another

Alicia L

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.

Alicia L

Thank you! This solved my issue.

Brian Wilson DC

@Alicia L it is because you are missing some information in your formula. I setup the following two sheets below. I have my source sheet which I made look like this:

And my destination sheet. The destination sheet I will show you in sections so you can see the INDEX/MATCH formula I used to gather the information. I renamed the ranges so they tell you exactly what column I used them to pull from on my original sheet.

For the date columns, make sure you set the column to a "date" column type, but you will need to un-toggle the "dates only" option so you can use a formula there to capture the date you want to import. Otherwise, it will flag you with an error.

I hope this helps!

Alicia L

Thank you! This solved my issue.