Match and Put row values


I have 2 sheets.

Sheet 1 and Sheet 2. Both have ID columns and column called vertical.

Need a formula that, if ID at the row from sheet 2 matches with ID in sheet 1 - then in the vertical column in sheet 2, I want to put the value from vertical column in Sheet 1.

Best Answer

  • Christian G.
    Christian G. ✭✭✭✭✭✭
    Answer ✓

    Hi @keesuri25

    in Sheet 2 vertical column use this formula

    =iferror(index({Sheet1 Vertical},match([Sheet 2ID]@row,{Sheet 1 ID},0)),"")

    Match will return a index of the ID position equal to Sheet2 ID located in Sheet 1 ID, or #NO MATCH error

    Index will return the value at the position given by the match function from the sheet1 vertical column

    Iferror catch the #NO MATCH error and output "" instead


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!