Formula to automatically pull cell data from one column of a source Smartsheet to another

System

This discussion was created from comments split from:

Automatically copy cells from one sheet to another

.

Rick Byers

I'm going to add to this string as I think they are related.

I need a formula that will automatically pull cell data from one column of a source Smartsheet and copy it to another Smartsheet.

For example: My source sheet is called "Creative Project List" that I want to automatically copy the column data in the "Project Title" column, to a different sheet "Marketing Project List" under "Project Title" column.

I have tried VLookup and Index, but do not understand how to set the search value and lookup table information.

Here's where I am:

=VLOOKUP({Creative Project List Range 1})

And returning: #incorrect argument set.

Thanks.

NicoLHC

@Rick Byers maybe you can try index match or collect ?

Genevieve P.

Hi @Rick Byers

I agree with @NicoLHC! Here's a Help Article that goes through how to structure an INDEX(MATCH type of formula:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations#toc-lookup-one-cell-using-a-matching-value

NicoLHC

@Rick Byers if you need more help feel free to share or invite me to the sheet . nico.roepnack@lighthouseconsultings.com