Help with Vlookup

I have seen other posts about this issue but not sure how they solved it... I am looking to use a vlookup to reference another sheet. I keep getting the #unparseable error.

I am looking to use the Primary Key column in the screenshot to pull from another Smartsheet (screenshot 2). Can you help me understand what I need to correct to enable this?


This is my source data. I am looking to pull from Primary Key through 34 more columns. Regardless, when I even just try to return column 2 (as indicated in the formula above), I receive an error. How do I enable vlookup?


Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @ColleenDeWeese

    I can't quite tell what is going on at the end of your formula because the text is too small. It looks like it maybe has an extra ) or } at the end of it. The formula should be:

    =VLOOKUP([Primary Key]@row, {Traceability Holds Tracker 2022 Range 3}, 2, false)

    If that doesn't work, then please take a screenshot of what the range {Traceability Holds Tracker 2022 Range 3} is mapped to. Maybe you didn't map the sheet properly for doing a VLOOKUP.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @ColleenDeWeese

    I can't quite tell what is going on at the end of your formula because the text is too small. It looks like it maybe has an extra ) or } at the end of it. The formula should be:

    =VLOOKUP([Primary Key]@row, {Traceability Holds Tracker 2022 Range 3}, 2, false)

    If that doesn't work, then please take a screenshot of what the range {Traceability Holds Tracker 2022 Range 3} is mapped to. Maybe you didn't map the sheet properly for doing a VLOOKUP.

  • @Mike TV That worked! Thank you so much for the help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!