Match and Put row values

keesuri25 · 11/09/22

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. · 11/10/22

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. · 11/10/22

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 · 11/10/22

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

keesuri25 · 11/10/22

=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. · 11/15/22

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

@keesuri25 Absolutly!

Match and Put row values

Best Answer

Answers

Help Article Resources

Categories