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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!