Vlookup #UNPARSEABLE Error linking to separate sheet

JMV

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!

Mark Cronk

Try:

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

Mark

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