Cross-Reference formulas

Hawka2810

Hi,

I have got an asset management template and I have converted to a master asset database and then a new sheet where inspection results against the assets are stored.

in the master database each asset has an asset ID. What I would like to do is if an asset ID is entered into the inspection results for it to then identify that ID in the master database and copy cells values across from various columns?

Paul Newcome

You would use an INDEX/MATCH for this:

=INDEX({Column To Pull Over}, MATCH([ID Column]@row, {ID Column}, 0))

MarceHolzhauzen

Hey @Hawka2810

There are a few ways to this.

Using a combination of INDEX and MATCH formulas will get you there, or have you seen the column links feature that is available?
https://help.smartsheet.com/articles/2483492-column-links-overview