Best Of

Hi @Monika_923

In Excel, you would use a formula something like this;

=INDEX('CC&Names'!B:B,MATCH('2025 OT Tracking SAMPLE'!B2,'CC&Names'!A:A,0))

Smartsheet formula is very similar to Excel, but there are a few differences.

First, when you input "=INDEX(" in a cell, you will get something like the below image asking you to set the range.

To reference another sheet, you click the Reference Another Sheet.

Then, you can search the sheet by name.

When you click the found sheet, you will see the preview of the sheet, like the image below.

When you click the column name, Cost Center, for example, the whole column will be selected, something equivalent to Excel's B:B.

Then, set the name of the range, CC&Names Range: Cost Center or Cost Center, for example.

It is a good practice to name the range like Sheet Name: Column Name or Sheet Name - Column Name, so that you can see where the range comes from easily.

When you hit 'Insert Reference', the range will be inserted like the image below.

Note, {range name} format is how Smartsheet indicates a range in a formula.

Second, like Excel, you use the MATCH function to get the row number that matches your criteria.

As shown below, Smartsheet uses column names, not like B2, and uses [Column Name]@row if you want to apply the formula to the whole column.

The way to reference another sheet's range is the same as explained above.

Search type is the same as Excel, 0, for an exact match, or the source sheet's data is random.

As shown below, the formula successfully got the corresponding Cost Center number.

Third, to populate the formula to the whole column, you use the "Convert to Column Formula" menu.

As shown below, when I apply the formula to the whole column, I get #NO MATCH errors.

To cope with the error, you can use the IFERROR function, as shown below.

In the example, I chose"" to place the blank if there is no match, but you can put something like "N/A" if you want.