Using formulas across different sheets

Nandini

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.

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

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