Incorrect Argument Set error when using Vlookup to reference another sheet.

Options

I am using a Vlookup to use a row id in sheet A to lookup the corresponding row id in sheet B and return the value in the status column - the syntax looks correct to me but I am getting an Incorrect Argument Set error.

This is the syntax I am using:

=VLOOKUP([Row ID]@row, {Cutover Tasks Range - Row ID}, 6, false)

Can you tell me what is wrong here?

Thanks

Tags:

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    Are all the Columns in the ref right next to each other. This requirement is why i prefer using Index Match

    =Index({Status Ref},Match([Row ID]@row,{Row ID Ref},0))

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • DLanca
    DLanca ✭✭
    Options

    Hello,

    Thanks for the info. I have tried the using Index Match as you suggested and am getting an #INVALID REF error on this:

    =INDEX({Range - Row ID}, MATCH([Row ID]@row, {Row ID Ref}, 6))

    Any ideas

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!