Copy column from 1 sheet to another
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.
Best Answer
-
Thank you! This solved my issue.
Answers
-
@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!
-
Thank you! This solved my issue.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!