Copy Date from one sheet to another if criteria matches

Hello all,

I have a master project sheet and I'd like to copy the date from another sheet into it.

Below is my master sheet and in the Milestone Date column, I want to copy the End Date from Project Sheet (below), if the "Primary Column" name from the Project sheet at each line matches the "Project Name" line name in the Master sheet.

To summarize, I want the date from the Project Sheet to be copied to the Master sheet if the names match in the Project Name and Primary columns.

What is the easiest way to do that?

This formula did. not work: =INDEX({ZLINE - Project Milestone Checklist End Date}, MATCH([Project Name]@row. {ZLINE - Project Milestone Checklist Primary Column}, 0))

Master Sheet

Screen Shot 2022-10-26 at 12.24.02 PM.png

Project Milestone Checklist

Screen Shot 2022-10-26 at 12.24.33 PM.png

Find more posts tagged with

Accepted answers

Ryan Sides

@Andrea Westrich

Hi Andrea, if your cross sheet references are setup correctly, it looks like your issue might be a typo.

Replace your period after @row with a comma.

=INDEX({ZLINE - Project Milestone Checklist End Date}, MATCH([Project Name]@row, {ZLINE - Project Milestone Checklist Primary Column}, 0))

All comments

Ryan Sides

@Andrea Westrich

Hi Andrea, if your cross sheet references are setup correctly, it looks like your issue might be a typo.

Replace your period after @row with a comma.

=INDEX({ZLINE - Project Milestone Checklist End Date}, MATCH([Project Name]@row, {ZLINE - Project Milestone Checklist Primary Column}, 0))

Andrea Westrich

Thanks @Ryan Sides. That is the formula I had, but I found out it did not work because if you look at my Project Checklist sheet, there are two cells that had Pre-Planning. Once I changed that, it worked.

Odd though, I could not copy it down. I had to retype the formula in some cells to get everything to work.

Thanks for your help!

Ryan Sides

@Andrea Westrich You bet! Happy to help and glad you got it figured out. - Ryan

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.