Using formulas across different sheets

Options

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.

Best Answer

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 09/06/23 Answer ✓
    Options

    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

    Sincerely,

    Jacob Stey

Answers

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 09/06/23 Answer ✓
    Options

    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

    Sincerely,

    Jacob Stey