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?

Find more posts tagged with

Accepted answers

Mike TV

@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.

All comments

Mike TV

@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.

ColleenDeWeese

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.