Match and Put row values

keesuri25

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.

Christian G.

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

Christian G.

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

keesuri25

That worked perfectly... Thank you so much..

keesuri25

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

In the above formula, instead of output "" for NO MATCH, how can i output @row value from another column ?

Something like

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

Christian G.

https://community.smartsheet.com/discussion/comment/350766#Comment_350766

@keesuri25 Absolutly!