Hey all,

I'm having trouble with a vlookup formula and not sure how to correct. I'm using the below -

=VLOOKUP([Task Name]@row, {Einstein Credits and Adjustments}, 8, false)

On the sheet where the formula is located, I want it to look up the column 'Task Name' then go to the second sheet 'Einstein Credits and Adjustments' and look up the value Task Name and bring back the results listed in column 8. When I enter this, I end up getting the Incorrect Argument Set error.

Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Double check that your range is actually covering all of the appropriate columns and that there are in fact 8 columns within the range. Column # 1 in this instance would be the far left column used for matching, so the column you are pulling from should be 7 more columns to the right.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!