Linking 2 Sheets and Finding the Same Information

Options

I want to link two sheets.

Sheet 1 contains multiple columns. (Column 1) Something is marked as approved. (Column 2) Contains multiple product codes/numbers. There are many rows of product codes and multiple approvals.

Sheet 2 contains multiple columns as well. (Column A) Something is marked as approved. (Column B) Contains multiple product codes/numbers. There are many rows of product codes and multiple approvals.

Essentially what I am looking looking for is if (Column 1) is marked as approved and has a certain product code (Column 2), I want it to find that same product code in Sheet 2 (Column B) and mark it as approved automatically Sheet 2 (Column A) instead of having to do it manually.

Is this possible?

Answers

  • James Keuning
    James Keuning ✭✭✭✭✭
    edited 05/26/21
    Options

    I think you will find that Sheet 2 needs to have three "Approved" columns. One that holds the approved value from from Sheet 2, one that holds the approved value from Sheet 1, and one that is a formula which looks at both columns and records Approved if either of the two is approved. This third column will be your "official" Approved value.

    Quickest way to get there is to use a VLOOKUP in sheet 2 to look for the value in sheet 1 and return the value, and OR in the third Approved column to consolidate the two columns.

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Options

    I know this question is from a couple weeks ago and you may have use James' solution or found your own but I think an index/match formula in Column A would work also

    =INDEX({Column 1}, MATCH([Column B]@row, {Column 2},0))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!