#NO MATCH Error when using VLOOKUP to look up the text displayed on a hyperlink

Options

Hi!


I'm trying to use vlookup to return data (a version number) using match data (document numbers). I have the VLOOKUP formula as =VLOOKUP([Document Number]1, {OP - Smartsheet Master Document List Range 2}, 7, false)

where

[Document Number]1 is a text/number column on the sheet I am working in

{OP - Smartsheet Master Document List Range 2} is a link to another smartsheet, where the document numbers are - but these cells contain a hyperlink


I'm getting a no match error with this set up. Any advice or alternative solutions?


Thank you

Tags:

Answers