Vlookup #UNPARSEABLE Error linking to separate sheet

Hi all - I'm receiving the #UNPARSEABLE error when trying to return a value matched via Study Number in another linked spreadsheet. Any thoughts?

=VLOOKUP([Study Number], {JMV Heme Study List_working Range 1},2,TRUE)

Do I need to be an administrator to perform this function on my sheet (I'm not)?

FUP question - once this formula is included on a sheet, am I able to override with text?

Thank you!

Find more posts tagged with

Accepted answers

Mark Cronk

Try:

=VLOOKUP([Study Number]@row, {JMV Heme Study List_working Range 1},2,TRUE)

Mark

All comments

Mark Cronk

Try:

=VLOOKUP([Study Number]@row, {JMV Heme Study List_working Range 1},2,TRUE)

Mark

JMV

Thanks Mark - that worked, strange the @row wasn't there when I initially created the VLOOKUP, when I tried again anew on another row it appeared and worked.

Mark Cronk

Perfect. Glad you found a solution. Thank you for contributing to the Community.

Mark

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.