Using formulas across different sheets

I am trying to figure out a formula that can help me cut down copy pasting between two sheets. Is there a formula I can use which when applied can duplicate the data from a row to another sheet with the same columns.

For example: I have sheet 1 which has columns Project ID and Project Name and Country.

In sheet 2 I have the same columns and I want when I type in just the same Project ID in sheet 2 the cells from sheet 1 are automatically populated in sheet 2. And also when data in sheet 1 is updated same can be updated in sheet 2 as well.

I hope this makes sense and is understandable.

Find more posts tagged with

Accepted answers

SteyJ

Hey @Nandini !

=INDEX({Project Name}, MATCH([Project ID]@row, {Project ID}), 0) -- Gets Project Name

=INDEX({Country}, MATCH([Project ID]@row, {Project ID}), 0) -- Gets Country for project name

For your cross sheet references, just select the entire column for {Country} and {Project ID}

Hope this helps

All comments

SteyJ

Hey @Nandini !

=INDEX({Project Name}, MATCH([Project ID]@row, {Project ID}), 0) -- Gets Project Name

=INDEX({Country}, MATCH([Project ID]@row, {Project ID}), 0) -- Gets Country for project name

For your cross sheet references, just select the entire column for {Country} and {Project ID}

Hope this helps

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.