# Match and Put row values

Options

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• Options

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

• Options
```=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)
```

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!