VLookUp - #INCORRECT ARGUMENT SET

Options

Hello team!

I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula:

=VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true)

7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets are in the same location.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!