Help with Vlookup

ColleenDeWeese

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?

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.

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!